SELECT  t0.page_id AS `page_id`,GROUP_CONCAT(t0.path SEPARATOR 0x1E) AS `p0`,GROUP_CONCAT(t0.value SEPARATOR 0x1E) AS `c0`,GROUP_CONCAT(t8.path SEPARATOR 0x1E) AS `p8`,GROUP_CONCAT(t8.value SEPARATOR 0x1E) AS `c8`,GROUP_CONCAT(t9.path SEPARATOR 0x1E) AS `p9`,GROUP_CONCAT(t9.value SEPARATOR 0x1E) AS `c9`  FROM (SELECT  t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id  FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id))   WHERE schema_id = '10' AND path_no_index = 'name'  ) `t0` LEFT JOIN (SELECT  t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id  FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id))   WHERE schema_id = '10' AND path_no_index = 'geolocation/latitude'  ) `t8` ON (((t8.page_id=t0.page_id))) LEFT JOIN (SELECT  t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id  FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id))   WHERE schema_id = '10' AND path_no_index = 'geolocation/longitude'  ) `t9` ON (((t9.page_id=t0.page_id) AND (t8.path_parent = t9.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE t0.schema_id = '10' AND ((t0.value = '{{{locations}}}'))  GROUP BY t0.page_id LIMIT 100