Test query b

{{#visualdataquery: [[states/name::+]][[states/cities/longitude::> 40]]
|schema=Country 
|?states/name=state name
|?states/cities/name=city name
|?states/cities/longitude
|format=table
|limit=100
}}

SELECT t0.page_id AS `page_id`,t0.value AS `v0`,t1.value AS `v1`,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 = '3' AND p.path_no_index = 'states/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 p.schema_id = '3' AND p.path_no_index = 'states/cities/longitude' ) `t1` ON (((t1.page_id=t0.page_id) AND (LOCATE( t0.path_parent, t1.path_parent ) = 1))) 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 = '3' AND p.path_no_index = 'states/cities/name' ) `t2` ON (((t2.page_id=t0.page_id) AND (t2.path_parent = t1.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value IS NOT NULL)) AND ((t1.value > 40)) LIMIT 100

page title	state name	city name	Longitude
Data:Countries/Afghanistan	Badakhshan	Ashkāsham	71.53333
Data:Countries/Afghanistan	Badakhshan	Fayzabad	70.58002
Data:Countries/Afghanistan	Badakhshan	Jurm	70.83421
Data:Countries/Afghanistan	Badakhshan	Khandūd	72.318
Data:Countries/Afghanistan	Badakhshan	Rāghistān	70.67346
Data:Countries/Afghanistan	Badakhshan	Wākhān	73.34928
Data:Countries/Afghanistan	Badghis	Ghormach	63.78264
Data:Countries/Afghanistan	Badghis	Qala i Naw	63.12891
Data:Countries/Afghanistan	Badghis	‘Alāqahdārī Dīshū	63.29802
Data:Countries/Afghanistan	Badghis	Gereshk	64.57005
Data:Countries/Afghanistan	Badghis	Lashkar Gāh	64.37161
Data:Countries/Afghanistan	Badghis	Markaz-e Ḩukūmat-e Darwēshān	64.1934
Data:Countries/Afghanistan	Badghis	Sangīn	64.8359
Data:Countries/Afghanistan	Badghis	Chahār Burj	62.19165
Data:Countries/Afghanistan	Badghis	Ghōriyān	61.49321
Data:Countries/Afghanistan	Badghis	Herāt	62.19967
Data:Countries/Afghanistan	Badghis	Kafir Qala	61.06667
Data:Countries/Afghanistan	Badghis	Karukh	62.5863
Data:Countries/Afghanistan	Badghis	Kuhsān	61.19778
Data:Countries/Afghanistan	Badghis	Kushk	61.95221
Data:Countries/Afghanistan	Badghis	Qarah Bāgh	61.77589
Data:Countries/Afghanistan	Badghis	Shīnḏanḏ	62.1474
Data:Countries/Afghanistan	Badghis	Tīr Pul	61.26895
Data:Countries/Afghanistan	Badghis	Zindah Jān	61.74675
Data:Countries/Afghanistan	Badghis	Āqchah	66.18341
Data:Countries/Afghanistan	Badghis	Darzāb	65.37828
Data:Countries/Afghanistan	Badghis	Qarqīn	66.04358
Data:Countries/Afghanistan	Badghis	Shibirghān	65.7529
Data:Countries/Afghanistan	Badghis	Kabul	69.17233
Data:Countries/Afghanistan	Badghis	Mīr Bachah Kōṯ	69.11899
Data:Countries/Afghanistan	Badghis	Paghmān	68.95091
Data:Countries/Afghanistan	Badghis	Kandahār	65.71013
Data:Countries/Afghanistan	Badghis	Sidqābād	69.35112
Data:Countries/Afghanistan	Badghis	Khōst	69.92041
Data:Countries/Afghanistan	Badghis	Asadabad	71.14697
Data:Countries/Afghanistan	Badghis	Āsmār	71.35809
Data:Countries/Afghanistan	Badghis	Dasht-e Archī	69.16667
Data:Countries/Afghanistan	Badghis	Imām Şāḩib	68.93644
Data:Countries/Afghanistan	Badghis	Khanabad	69.11556
Data:Countries/Afghanistan	Badghis	Kunduz	68.857
Data:Countries/Afghanistan	Badghis	Qarāwul	68.7802
Data:Countries/Afghanistan	Badghis	Mehtar Lām	70.20944
Data:Countries/Afghanistan	Baghlan	Baghlān	68.70829
Data:Countries/Afghanistan	Baghlan	Ḩukūmatī Dahanah-ye Ghōrī	68.48869
Data:Countries/Afghanistan	Baghlan	Nahrīn	69.13343
Data:Countries/Afghanistan	Baghlan	Pul-e Khumrī	68.71512
Data:Countries/Afghanistan	Baghlan	Baraki Barak	68.9492
Data:Countries/Afghanistan	Baghlan	Ḩukūmatī Azrah	69.64573
Data:Countries/Afghanistan	Baghlan	Pul-e ‘Alam	69.02274
Data:Countries/Afghanistan	Baghlan	Bāsawul	70.87218
Data:Countries/Afghanistan	Baghlan	Jalālābād	70.45153
Data:Countries/Afghanistan	Baghlan	Markaz-e Woluswalī-ye Āchīn	70.70778
Data:Countries/Afghanistan	Baghlan	Khāsh	62.79055
Data:Countries/Afghanistan	Baghlan	Mīrābād	61.8383
Data:Countries/Afghanistan	Baghlan	Rūdbār	62.6
Data:Countries/Afghanistan	Baghlan	Zaranj	61.86037
Data:Countries/Afghanistan	Baghlan	Pārūn	70.92261
Data:Countries/Afghanistan	Baghlan	Gardez	69.22592
Data:Countries/Afghanistan	Baghlan	Saṟōbī	69.04587
Data:Countries/Afghanistan	Baghlan	Zaṟah Sharan	68.79213
Data:Countries/Afghanistan	Baghlan	Zarghūn Shahr	68.44573
Data:Countries/Afghanistan	Baghlan	Bāzārak	69.51519
Data:Countries/Afghanistan	Baghlan	Charikar	69.17139
Data:Countries/Afghanistan	Baghlan	Jabal os Saraj	69.23778
Data:Countries/Afghanistan	Baghlan	Aībak	68.01551
Data:Countries/Afghanistan	Baghlan	Chīras	65.98234
Data:Countries/Afghanistan	Baghlan	Larkird	66.66409
Data:Countries/Afghanistan	Baghlan	Qal‘ah-ye Shahr	65.5676
Data:Countries/Afghanistan	Baghlan	Sang-e Chārak	66.43694
Data:Countries/Afghanistan	Baghlan	Sar-e Pul	65.93249
Data:Countries/Afghanistan	Baghlan	Tagāw-Bāy	66.06164
Data:Countries/Afghanistan	Baghlan	Tukzār	66.42132
Data:Countries/Afghanistan	Balkh	Balkh	66.8972
Data:Countries/Afghanistan	Balkh	Dowlatābād	66.82069
Data:Countries/Afghanistan	Balkh	Khulm	67.69826
Data:Countries/Afghanistan	Balkh	Lab-Sar	66.83799
Data:Countries/Afghanistan	Balkh	Mazār-e Sharīf	67.11087
Data:Countries/Afghanistan	Balkh	Qarchī Gak	66.78891
Data:Countries/Afghanistan	Balkh	Ārt Khwājah	69.47958
Data:Countries/Afghanistan	Balkh	Taloqan	69.53451
Data:Countries/Afghanistan	Balkh	Tarinkot	65.87806
Data:Countries/Afghanistan	Balkh	Uruzgān	66.63253
Data:Countries/Afghanistan	Balkh	Qalāt	66.90833
Data:Countries/Afghanistan	Bamyan	Bāmyān	67.82734
Data:Countries/Afghanistan	Bamyan	Panjāb	67.02327
Data:Countries/Afghanistan	Daykundi	Nīlī	66.07617
Data:Countries/Afghanistan	Farah	Farah	62.11638
Data:Countries/Afghanistan	Faryab	Andkhoy	65.12376
Data:Countries/Afghanistan	Faryab	Maymana	64.78361
Data:Countries/Afghanistan	Ghazni	Ghazni	68.42096
Data:Countries/Afghanistan	Ghōr	Fayrōz Kōh	65.25093
Data:Countries/Afghanistan	Ghōr	Shahrak	64.3052
Data:Countries/Afghanistan	Helmand	‘Alāqahdārī Dīshū	63.29802
Data:Countries/Afghanistan	Helmand	Gereshk	64.57005
Data:Countries/Afghanistan	Helmand	Lashkar Gāh	64.37161
Data:Countries/Afghanistan	Helmand	Markaz-e Ḩukūmat-e Darwēshān	64.1934
Data:Countries/Afghanistan	Helmand	Sangīn	64.8359
Data:Countries/Afghanistan	Herat	Chahār Burj	62.19165
Data:Countries/Afghanistan	Herat	Ghōriyān	61.49321
Data:Countries/Afghanistan	Herat	Herāt	62.19967