Test query b

From Wikisphere
Jump to navigation Jump to search 
{{#visualdataquery: [[states/name::+]][[states/cities/longitude::> 40]]
|schema=Country 
|?states/name
|?states/cities/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 schema_id = '3' AND 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 schema_id = '3' AND 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 schema_id = '3' AND path_no_index = 'states/cities/name' ) `t2` ON (((t2.page_id=t0.page_id) AND (t1.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE t0.schema_id = '3' AND ((t0.value IS NOT NULL)) AND ((t1.value > 40)) LIMIT 100


page titleNameNameLongitude
Data:Countries/AfghanistanBadakhshanAshkāsham71.53333
Data:Countries/AfghanistanBadakhshanFayzabad70.58002
Data:Countries/AfghanistanBadakhshanJurm70.83421
Data:Countries/AfghanistanBadakhshanKhandūd72.318
Data:Countries/AfghanistanBadakhshanRāghistān70.67346
Data:Countries/AfghanistanBadakhshanWākhān73.34928
Data:Countries/ArmeniaAragatsotn RegionAgarakavan44.07233
Data:Countries/ArmeniaAragatsotn RegionAparan44.3589
Data:Countries/ArmeniaAragatsotn RegionAragats44.3529
Data:Countries/ArmeniaAragatsotn RegionArteni43.76672
Data:Countries/ArmeniaAragatsotn RegionAshnak43.91669
Data:Countries/ArmeniaAragatsotn RegionAshtarak44.36204
Data:Countries/ArmeniaAragatsotn RegionByurakan44.27275
Data:Countries/ArmeniaAragatsotn RegionHnaberd44.14058
Data:Countries/ArmeniaAragatsotn RegionKarbi44.37793
Data:Countries/ArmeniaAragatsotn RegionKasakh44.41046
Data:Countries/ArmeniaAragatsotn RegionKosh44.16107
Data:Countries/ArmeniaAragatsotn RegionNor Yerznka44.38892
Data:Countries/ArmeniaAragatsotn RegionOshakan44.31671
Data:Countries/ArmeniaAragatsotn RegionSasunik44.34448
Data:Countries/ArmeniaAragatsotn RegionShenavan44.38348
Data:Countries/ArmeniaAragatsotn RegionT’alin43.87793
Data:Countries/ArmeniaAragatsotn RegionTsaghkahovit44.22241
Data:Countries/ArmeniaAragatsotn RegionUshi44.37512
Data:Countries/ArmeniaAragatsotn RegionVoskevaz44.30011
Data:Countries/ArmeniaAragatsotn RegionZovuni44.4389
Data:Countries/AustraliaAustralian Capital TerritoryActon149.11829
Data:Countries/AustraliaAustralian Capital TerritoryAinslie149.1437
Data:Countries/AustraliaAustralian Capital TerritoryAmaroo149.12802
Data:Countries/AustraliaAustralian Capital TerritoryAranda149.0804
Data:Countries/AustraliaAustralian Capital TerritoryBanks149.09965
Data:Countries/AustraliaAustralian Capital TerritoryBarton149.14121
Data:Countries/AustraliaAustralian Capital TerritoryBelconnen149.06627
Data:Countries/AustraliaAustralian Capital TerritoryBonner149.13855
Data:Countries/AustraliaAustralian Capital TerritoryBonython149.07822
Data:Countries/AustraliaAustralian Capital TerritoryBraddon149.13569
Data:Countries/AustraliaAustralian Capital TerritoryBruce149.09083
Data:Countries/AustraliaAustralian Capital TerritoryCalwell149.10707
Data:Countries/AustraliaAustralian Capital TerritoryCampbell149.15382
Data:Countries/AustraliaAustralian Capital TerritoryCanberra149.12807
Data:Countries/AustraliaAustralian Capital TerritoryCasey149.0947
Data:Countries/AustraliaAustralian Capital TerritoryChapman149.03742
Data:Countries/AustraliaAustralian Capital TerritoryCharnwood149.03412
Data:Countries/AustraliaAustralian Capital TerritoryChifley149.07684
Data:Countries/AustraliaAustralian Capital TerritoryChisholm149.12825
Data:Countries/AustraliaAustralian Capital TerritoryCity149.12927
Data:Countries/AustraliaAustralian Capital TerritoryConder149.10422
Data:Countries/AustraliaAustralian Capital TerritoryCook149.06566
Data:Countries/AustraliaAustralian Capital TerritoryCoombs149.03941
Data:Countries/AustraliaAustralian Capital TerritoryCrace149.10736
Data:Countries/AustraliaAustralian Capital TerritoryCurtin149.07763
Data:Countries/AustraliaAustralian Capital TerritoryDeakin149.10308
Data:Countries/AustraliaAustralian Capital TerritoryDickson149.13932
Data:Countries/AustraliaAustralian Capital TerritoryDowner149.14468
Data:Countries/AustraliaAustralian Capital TerritoryDuffy149.03188
Data:Countries/AustraliaAustralian Capital TerritoryDunlop149.01984
Data:Countries/AustraliaAustralian Capital TerritoryEvatt149.06891
Data:Countries/AustraliaAustralian Capital TerritoryFadden149.11662
Data:Countries/AustraliaAustralian Capital TerritoryFarrer149.105
Data:Countries/AustraliaAustralian Capital TerritoryFisher149.05704
Data:Countries/AustraliaAustralian Capital TerritoryFlorey149.05
Data:Countries/AustraliaAustralian Capital TerritoryFlynn149.04389
Data:Countries/AustraliaAustralian Capital TerritoryForde149.14607
Data:Countries/AustraliaAustralian Capital TerritoryForrest149.12859
Data:Countries/AustraliaAustralian Capital TerritoryFranklin149.14329
Data:Countries/AustraliaAustralian Capital TerritoryFraser149.04534
Data:Countries/AustraliaAustralian Capital TerritoryGarran149.10846
Data:Countries/AustraliaAustralian Capital TerritoryGilmore149.13481
Data:Countries/AustraliaAustralian Capital TerritoryGiralang149.096
Data:Countries/AustraliaAustralian Capital TerritoryGordon149.08498
Data:Countries/AustraliaAustralian Capital TerritoryGowrie149.10903
Data:Countries/AustraliaAustralian Capital TerritoryGreenway149.06658
Data:Countries/AustraliaAustralian Capital TerritoryGriffith149.13714
Data:Countries/AustraliaAustralian Capital TerritoryGungahlin149.13619
Data:Countries/AustraliaAustralian Capital TerritoryHackett149.16352
Data:Countries/AustraliaAustralian Capital TerritoryHarrison149.15631
Data:Countries/AustraliaAustralian Capital TerritoryHawker149.03666
Data:Countries/AustraliaAustralian Capital TerritoryHiggins149.0272
Data:Countries/AustraliaAustralian Capital TerritoryHolder149.04614
Data:Countries/AustraliaAustralian Capital TerritoryHolt149.01188
Data:Countries/AustraliaAustralian Capital TerritoryHughes149.09491
Data:Countries/AustraliaAustralian Capital TerritoryIsaacs149.11555
Data:Countries/AustraliaAustralian Capital TerritoryIsabella Plains149.08795
Data:Countries/AustraliaAustralian Capital TerritoryKaleen149.10516
Data:Countries/AustraliaAustralian Capital TerritoryKambah149.05804
Data:Countries/AustraliaAustralian Capital TerritoryKingston149.14658
Data:Countries/AustraliaAustralian Capital TerritoryLatham149.03144
Data:Countries/AustraliaAustralian Capital TerritoryLyneham149.13074
Data:Countries/AustraliaAustralian Capital TerritoryLyons149.07396
Data:Countries/AustraliaAustralian Capital TerritoryMacarthur149.12696
Data:Countries/AustraliaAustralian Capital TerritoryMacgregor149.01101
Data:Countries/AustraliaAustralian Capital TerritoryMacquarie149.06363
Data:Countries/AustraliaAustralian Capital TerritoryMawson149.09863
Data:Countries/AustraliaAustralian Capital TerritoryMcKellar149.07704
Data:Countries/AustraliaAustralian Capital TerritoryMelba149.05405
Data:Countries/AustraliaAustralian Capital TerritoryMonash149.09063
Data:Countries/AustraliaAustralian Capital TerritoryNarrabundah149.14924
Data:Countries/AustraliaAustralian Capital TerritoryNgunnawal149.11147
Data:Countries/AustraliaAustralian Capital TerritoryNicholls149.09648
Data:Countries/AustraliaAustralian Capital TerritoryO'Connor149.11248
Retrieved from "https://www.wikisphere.org/w/index.php?title=Test_query_b&oldid=31537"