Array ( [t0] => Wikimedia\Rdbms\Subquery Object ( [sql:Wikimedia\Rdbms\Subquery:private] => 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 p.schema_id = '22' AND p.path_no_index = 'hash' ) [t1] => Wikimedia\Rdbms\Subquery Object ( [sql:Wikimedia\Rdbms\Subquery:private] => 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 p.schema_id = '22' AND p.path_no_index = 'addresses' ) [page_alias] => page ) Array ( [page_id] => t0.page_id [c0] => GROUP_CONCAT(t0.value SEPARATOR 0x1E) [p1] => GROUP_CONCAT(t1.path SEPARATOR 0x1E) [c1] => GROUP_CONCAT(t1.value SEPARATOR 0x1E) ) Array ( [0] => (t0.value = '') ) Array ( [LIMIT] => 1 [GROUP BY] => t0.page_id ) Array ( [t1] => Array ( [0] => LEFT JOIN [1] => (t1.page_id=t0.page_id) ) [page_alias] => Array ( [0] => JOIN [1] => Array ( [0] => page_alias.page_id = t0.page_id ) ) )