Test query

{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]]
|schema=Country 
|?states/cities/name
|?states/cities/latitude
|format=datatable 
|hierarchical-conditions=true 
}} 

SELECT t0.page_id AS `page_id`,t2.value AS `v2`,t3.value AS `v3` FROM (SELECT t.page_id,p.path_parent,t.value 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' ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value 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' ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value 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' ) `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 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' ) `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')) LIMIT 100

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

page title	Name	Latitude
Data:Countries/Afghanistan	Ashkāsham	36.68333

{{#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 
}} 

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

{{#visualdataquery:[[name::Afghanistan]]
|schema=Country 
|?states/name
|?states/state_code
|format=table 
}}

page title	Name	State code
Data:Countries/Afghanistan	Badakhshan	BDS
Data:Countries/Afghanistan	Badghis	BDG
Data:Countries/Afghanistan	Baghlan	BGL
Data:Countries/Afghanistan	Balkh	BAL
Data:Countries/Afghanistan	Bamyan	BAM
Data:Countries/Afghanistan	Daykundi	DAY
Data:Countries/Afghanistan	Farah	FRA
Data:Countries/Afghanistan	Faryab	FYB
Data:Countries/Afghanistan	Ghazni	GHA
Data:Countries/Afghanistan	Ghōr	GHO
Data:Countries/Afghanistan	Helmand	HEL
Data:Countries/Afghanistan	Herat	HER
Data:Countries/Afghanistan	Jowzjan	JOW
Data:Countries/Afghanistan	Kabul	KAB
Data:Countries/Afghanistan	Kandahar	KAN
Data:Countries/Afghanistan	Kapisa	KAP
Data:Countries/Afghanistan	Khost	KHO
Data:Countries/Afghanistan	Kunar	KNR
Data:Countries/Afghanistan	Kunduz Province	KDZ
Data:Countries/Afghanistan	Laghman	LAG
Data:Countries/Afghanistan	Logar	LOG
Data:Countries/Afghanistan	Nangarhar	NAN
Data:Countries/Afghanistan	Nimruz	NIM
Data:Countries/Afghanistan	Nuristan	NUR
Data:Countries/Afghanistan	Paktia	PIA
Data:Countries/Afghanistan	Paktika	PKA
Data:Countries/Afghanistan	Panjshir	PAN
Data:Countries/Afghanistan	Parwan	PAR
Data:Countries/Afghanistan	Samangan	SAM
Data:Countries/Afghanistan	Sar-e Pol	SAR
Data:Countries/Afghanistan	Takhar	TAK
Data:Countries/Afghanistan	Urozgan	URU
Data:Countries/Afghanistan	Zabul	ZAB

{{#visualdataquery:
[[name::Afghanistan]][[states/cities/name::K~]]
|schema=Country
|?states/name 
|?states/cities/name 
|?states/cities/latitude 
|limit=4 
|format=table 
}}

page title	Name	Name	Latitude
Data:Countries/Canada	Quebec	Abitibi-Témiscamingue	48.10018
Data:Countries/Canada	Quebec	Acton Vale	45.65007
Data:Countries/Canada	Quebec	Adstock	46.05007
Data:Countries/Canada	Quebec	Albanel	48.88324
Data:Countries/Canada	Quebec	Alma	48.55009
Data:Countries/Canada	Quebec	Amos	48.56688
Data:Countries/Canada	Quebec	Amqui	48.46382
Data:Countries/Canada	Quebec	Ange-Gardien	45.35008
Data:Countries/Canada	Quebec	Asbestos	45.76678
Data:Countries/Canada	Quebec	Baie-Comeau	49.21679
Data:Countries/Canada	Quebec	Baie-D'Urfé	45.41397
Data:Countries/Canada	Quebec	Baie-Saint-Paul	47.44109
Data:Countries/Canada	Quebec	Barraute	48.43349
Data:Countries/Canada	Quebec	Bas-Saint-Laurent	48.0503
Data:Countries/Canada	Quebec	Beaconsfield	45.43341
Data:Countries/Canada	Quebec	Beauceville	46.21785
Data:Countries/Canada	Quebec	Beauharnois	45.31341
Data:Countries/Canada	Quebec	Beaupré	47.04428
Data:Countries/Canada	Quebec	Bécancour	46.34106
Data:Countries/Canada	Quebec	Bedford	45.11678
Data:Countries/Canada	Quebec	Beloeil	45.56839
Data:Countries/Canada	Quebec	Berthierville	46.08336
Data:Countries/Canada	Quebec	Blainville	45.66678
Data:Countries/Canada	Quebec	Bois-des-Filion	45.66678
Data:Countries/Canada	Quebec	Boisbriand	45.61678
Data:Countries/Canada	Quebec	Bonaventure	48.04573
Data:Countries/Canada	Quebec	Boucherville	45.59104
Data:Countries/Canada	Quebec	Breakeyville	46.68037
Data:Countries/Canada	Quebec	Bromont	45.31678
Data:Countries/Canada	Quebec	Brossard	45.45008
Data:Countries/Canada	Quebec	Brownsburg-Chatham	45.68342
Data:Countries/Canada	Quebec	Buckingham	45.58563
Data:Countries/Canada	Quebec	Cabano	47.68065
Data:Countries/Canada	Quebec	Cacouna	47.91657
Data:Countries/Canada	Quebec	Candiac	45.38338
Data:Countries/Canada	Quebec	Cantley	45.5668
Data:Countries/Canada	Quebec	Cap-Chat	49.10009
Data:Countries/Canada	Quebec	Cap-Santé	46.67159
Data:Countries/Canada	Quebec	Capitale-Nationale	47.376
Data:Countries/Canada	Quebec	Carignan	45.45008
Data:Countries/Canada	Quebec	Carleton	48.09838
Data:Countries/Canada	Quebec	Carleton-sur-Mer	48.10749
Data:Countries/Canada	Quebec	Centre-du-Québec	46.01985
Data:Countries/Canada	Quebec	Chambly	45.45008
Data:Countries/Canada	Quebec	Chambord	48.43339
Data:Countries/Canada	Quebec	Chandler	48.34935
Data:Countries/Canada	Quebec	Chapais	49.78344
Data:Countries/Canada	Quebec	Charlemagne	45.71678
Data:Countries/Canada	Quebec	Château-Richer	46.96031
Data:Countries/Canada	Quebec	Châteauguay	45.38338