string(1068) "SELECT `t`.`id` AS `id`, `t`.`name` AS `name`, `tl`.`title` AS `title`, `tl`.`description` AS `description`, `ti`.`name` AS `list_name`, `til`.`title` AS `list_title`, COUNT(bt.entity_id) AS `businesses`, GROUP_CONCAT(e.id ORDER BY e.featured DESC, e.weight, el.name) AS `business_ids` FROM `cms_tag` AS `t` LEFT JOIN `cms_language` AS `l` ON l.code = 'en' LEFT JOIN `cms_tag_lang` AS `tl` ON tl.entity_id = t.id AND tl.lang_id = l.id LEFT JOIN `cms_tag_list` AS `ti` ON ti.id = t.list_id LEFT JOIN `cms_tag_list_lang` AS `til` ON til.entity_id = ti.id AND til.lang_id = l.id LEFT JOIN `cms_business_features_tag` AS `bt` ON bt.tag_id = t.id INNER JOIN `cms_business` AS `b` ON b.id = bt.entity_id AND b.public = '1' AND b.deleted = '0' LEFT JOIN `cms_business` AS `e` ON e.id = bt.entity_id LEFT JOIN `cms_business_lang` AS `el` ON el.entity_id = e.id AND el.lang_id = l.id WHERE `ti`.`entity_name` = 'business_features' AND el.name <> '' GROUP BY `t`.`id` ORDER BY `ti`.`delta` ASC, `ti`.`id` ASC, `t`.`delta` ASC, `t`.`id` ASC, `e`.`featured` DESC, `e`.`weight` ASC"
Dental clinics a Velika Gorica - What Dentist