Test query e

{{#visualdataquery:[[name::Afghanistan]]   [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/restaurants/name::bbb]]    
|schema=Country
|?states/cities/name
|?states/cities/latitude
|format=json
|hierarchical-conditions=true
|pagetitle-name=article 
}}

SELECT t0.page_id AS `page_id`,c0,c1,p2,c2,c2,p3,c3 FROM (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p0,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c0 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' GROUP BY t.page_id ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p1,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c1 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' GROUP BY t.page_id ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p2,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c2 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/name' GROUP BY t.page_id ) `t2` ON (((t2.page_id=t0.page_id) AND (LOCATE( t1.path_parent, t2.path_parent ) = 1))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p3,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c3 FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/latitude' GROUP BY t.page_id ) `t3` ON (((t3.page_id=t0.page_id) AND (t3.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Afghanistan')) AND ((t1.value = 'Badakhshan')) AND ((t2.value LIKE 'A%' ESCAPE '`')) GROUP BY t0.page_id LIMIT 100

title "Data:Countries/Afghanistan" pageid 710 data states cities name "Ashkāsham" latitude 36.68333 name "Fayzabad" latitude 37.11664 name "Jurm" latitude 36.86477 name "Khandūd" latitude 36.95127 name "Rāghistān" latitude 37.66079 name "Wākhān" latitude 37.0571 cities name "Ghormach" latitude 35.73062 name "Qala i Naw" latitude 34.98735 cities name "Baghlān" latitude 36.13068 name "Ḩukūmatī Dahanah-ye Ghōrī" latitude 35.90617 name "Nahrīn" latitude 36.0649 name "Pul-e Khumrī" latitude 35.94458 cities name "Balkh" latitude 36.75635 name "Dowlatābād" latitude 36.98821 name "Khulm" latitude 36.69736 name "Lab-Sar" latitude 36.02634 name "Mazār-e Sharīf" latitude 36.70904 name "Qarchī Gak" latitude 37.03999 cities name "Bāmyān" latitude 34.82156 name "Panjāb" latitude 34.38795 cities name "Nīlī" latitude 33.76329 cities name "Farah" latitude 32.37451 cities name "Andkhoy" latitude 36.95293 name "Maymana" latitude 35.92139 cities name "Ghazni" latitude 33.55391 cities name "Fayrōz Kōh" latitude 34.51952 name "Shahrak" latitude 34.10737 cities name "‘Alāqahdārī Dīshū" latitude 30.43206 name "Gereshk" latitude 31.82089 name "Lashkar Gāh" latitude 31.59382 name "Markaz-e Ḩukūmat-e Darwēshān" latitude 31.13231 name "Sangīn" latitude 32.07275 cities name "Chahār Burj" latitude 34.24475 name "Ghōriyān" latitude 34.3448 name "Herāt" latitude 34.34817 name "Kafir Qala" latitude 34.66667 name "Karukh" latitude 34.48108 name "Kuhsān" latitude 34.65389 name "Kushk" latitude 33.29565 name "Qarah Bāgh" latitude 34.94023 name "Shīnḏanḏ" latitude 33.30294 name "Tīr Pul" latitude 34.59431 name "Zindah Jān" latitude 34.34264 cities name "Āqchah" latitude 36.905 name "Darzāb" latitude 35.97744 name "Qarqīn" latitude 37.41853 name "Shibirghān" latitude 36.66757 cities name "Kabul" latitude 34.52813 name "Mīr Bachah Kōṯ" latitude 34.74999 name "Paghmān" latitude 34.58787 cities name "Kandahār" latitude 31.61332 cities name "Sidqābād" latitude 35.02298 cities name "Khōst" latitude 33.33951 cities name "Asadabad" latitude 34.87311 name "Āsmār" latitude 35.03333 cities name "Dasht-e Archī" latitude 37.13333 name "Imām Şāḩib" latitude 37.18897 name "Khanabad" latitude 36.6825 name "Kunduz" latitude 36.72895 name "Qarāwul" latitude 37.21959 cities name "Mehtar Lām" latitude 34.67139 cities name "Baraki Barak" latitude 33.96744 name "Ḩukūmatī Azrah" latitude 34.17355 name "Pul-e ‘Alam" latitude 33.99529 cities name "Bāsawul" latitude 34.24749 name "Jalālābād" latitude 34.42647 name "Markaz-e Woluswalī-ye Āchīn" latitude 34.12583 cities name "Khāsh" latitude 31.52919 name "Mīrābād" latitude 30.43624 name "Rūdbār" latitude 30.15 name "Zaranj" latitude 30.95962 cities name "Pārūn" latitude 35.42064 cities name "Gardez" latitude 33.59744 cities name "Saṟōbī" latitude 32.75221 name "Zaṟah Sharan" latitude 33.14641 name "Zarghūn Shahr" latitude 32.84734 cities name "Bāzārak" latitude 35.31292 cities name "Charikar" latitude 35.01361 name "Jabal os Saraj" latitude 35.11833 cities name "Aībak" latitude 36.26468 cities name "Chīras" latitude 35.41674 name "Larkird" latitude 35.48936 name "Qal‘ah-ye Shahr" latitude 35.54729 name "Sang-e Chārak" latitude 35.84972 name "Sar-e Pul" latitude 36.21544 name "Tagāw-Bāy" latitude 35.69941 name "Tukzār" latitude 35.94831 cities name "Ārt Khwājah" latitude 37.08571 name "Taloqan" latitude 36.73605 cities name "Tarinkot" latitude 32.62998 name "Uruzgān" latitude 32.92775 cities name "Qalāt" latitude 32.10575