SELECT  t0.page_id AS `page_id`,t0.value AS `v0`,t2.value AS `v2`  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 p.schema_id = '9' AND p.path_no_index = 'person'  ) `t0` LEFT JOIN (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 = '9' AND p.path_no_index = 'organization'  ) `t1` ON (((t1.page_id=t0.page_id) AND (t1.path_parent = t0.path_parent))) LEFT JOIN (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 = '9' AND p.path_no_index = 'role'  ) `t2` ON (((t2.page_id=t0.page_id) AND (t2.path_parent = t0.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE ((t0.value IS NOT NULL)) AND ((t1.value = '<organizations/name>'))  LIMIT 100  SELECT  t0.page_id AS `page_id`,t0.value AS `v0`  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 p.schema_id = '10' AND p.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_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id))   WHERE p.schema_id = '10' AND p.path_no_index = 'organization'  ) `t1` ON (((t1.page_id=t0.page_id) AND (t1.path_parent = t0.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE ((t0.value IS NOT NULL)) AND ((t1.value = '<organization>'))  LIMIT 100  SELECT  t0.page_id AS `page_id`,t0.value AS `v0`  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 p.schema_id = '8' AND p.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_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id))   WHERE p.schema_id = '8' AND p.path_no_index = 'organization'  ) `t1` ON (((t1.page_id=t0.page_id) AND (t1.path_parent = t0.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE ((t0.value IS NOT NULL)) AND ((t1.value = '<organizations/name>'))  LIMIT 100  SELECT  t0.page_id AS `page_id`,t1.value AS `v1`  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 p.schema_id = '12' AND p.path_no_index = 'organization'  ) `t0` LEFT JOIN (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 = '12' AND p.path_no_index = 'address'  ) `t1` ON (((t1.page_id=t0.page_id) AND (t1.path_parent = t0.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE ((t0.value = '<organizations/name>'))  LIMIT 100  SELECT  t0.page_id AS `page_id`,t0.value AS `v0`  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 p.schema_id = '5' AND p.path_no_index = 'project_number'  ) `t0` JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id))   WHERE ((t0.value IS NOT NULL))  LIMIT 100