number of errors=449
number of warnings=0
Group=ckgGrpPopulation
Group=ckgGrpWP
select geoname.geonameid,ansiname,featurecode,geoname.countrycode,wikipedia.relevance from geoname,geoname_datasource,wikipedia where featureclass='P' and featurecode not in ('PPLQ') and coalesce(geoname.population,0)=0 and geoname.geonameid=geoname_datasource.geonameid and userid=8 and nameorid=wikipediaid::text and wikipedia.relevance>1000 order by wikipedia.relevance desc
[{key=GB,number=119}, {key=US,number=86}, {key=CA,number=68}, {key=IN,number=16}, {key=ZA,number=9}, {key=BR,number=7}, {key=NL,number=7}, {key=AU,number=6}, {key=DE,number=6}, {key=MX,number=6}, {key=BG,number=5}, {key=IT,number=5}, {key=PL,number=5}, {key=TR,number=5}, {key=GR,number=4}, {key=IE,number=4}, {key=NO,number=4}, {key=PK,number=4}, {key=TT,number=4}, {key=CN,number=3}, {key=DK,number=3}, {key=ES,number=3}, {key=ID,number=3}, {key=IL,number=3}, {key=IQ,number=3}, {key=MY,number=3}, {key=NZ,number=3}, {key=PH,number=3}, {key=VE,number=3}, {key=FR,number=2}, {key=LB,number=2}, {key=LK,number=2}, {key=LT,number=2}, {key=MZ,number=2}, {key=SA,number=2}, {key=ZW,number=2}, {key=AR,number=1}, {key=BE,number=1}, {key=BF,number=1}, {key=CM,number=1}, {key=CO,number=1}, {key=CZ,number=1}, {key=DM,number=1}, {key=DO,number=1}, {key=DZ,number=1}, {key=EE,number=1}, {key=EG,number=1}, {key=ER,number=1}, {key=ET,number=1}, {key=FI,number=1}, {key=HR,number=1}, {key=IR,number=1}, {key=JP,number=1}, {key=KE,number=1}, {key=KP,number=1}, {key=LV,number=1}, {key=MS,number=1}, {key=NG,number=1}, {key=NP,number=1}, {key=RO,number=1}, {key=RU,number=1}, {key=RW,number=1}, {key=SD,number=1}, {key=SK,number=1}, {key=SO,number=1}, {key=SV,number=1}, {key=TZ,number=1}, {key=UA,number=1}, {key=VU,number=1}, {key=XK,number=1}, {key=YE,number=1}]
geonameid ansiname featurecode countrycode relevance 6167863 Downtown Toronto PPLX CA 2000 3530977 Chichen-Itza PPLL MX 1568 3575717 Massacre PPL DM 1360 3086822 Ruda PPL PL 1290 2619940 Hoje Tastrup PPL DK 1280 1283617 Bhaktapur PPLA3 NP 1280 157382 Kilwa Kisiwani PPL TZ 1260 3822506 Mayapan PPL MX 1260 649919 Kuusankoski PPL FI 1240 2793656 Laeken PPL BE 1240 747059 Galata PPLX TR 1220 3021399 Dieudonne PPL FR 1220 3585420 Joya de Ceren PPL SV 1204 3626045 Tovar PPL VE 1200 3578069 Plymouth PPLC MS 1198 6355005 Slanchev Bryag PPL BG 1186 1703010 Malasiqui PPLA3 PH 1180 6269270 EUR PPLX IT 1180 2964724 Doolin PPL IE 1177 1791245 Changle PPL CN 1160 751214 Bakirkoey PPL TR 1160 99172 Al Kazimiyah PPLX IQ 1160 1281251 Gandaingoin PPL CN 1140 3465339 Corumba de Goias PPL BR 1140 2657867 Abbotsford PPL GB 1140 735181 Mesolouri PPL GR 1140 3429595 Recoleta PPLX AR 1140 3467801 Campo Alegre de Goias PPL BR 1140 776551 Babsk PPL PL 1132 6142001 Schefferville PPL CA 1120 2932843 Ehrenbreitstein PPLX DE 1120 3471286 Avelinopolis PPL BR 1120 6545251 South Bank PPLX GB 1120 65171 Bardera PPL SO 1120 265846 Zgharta PPLA2 LB 1120 1279311 Adyar PPL IN 1120 1970280 Shamian PPL CN 1120 2514457 Los Sauces PPL ES 1120 3111465 Roda de Ter PPL ES 1119 3515368 Tlatilco PPLX MX 1102 2650621 Durness PPL GB 1100 5924617 Cochrane PPL CA 1100 2637299 Southwark PPLX GB 1100 281168 Talpiyyot PPL IL 1100 449176 Badme PPL ER 1100 2753201 Jordaan PPLX NL 1100 251667 Vravrona PPL GR 1100 3365957 Khayelitsha PPL ZA 1100 3017458 Fourviere PPLX FR 1100 2499912 Djemila PPL DZ 1099 3460367 Jacarepagua PPL BR 1099 3066938 Rejviz PPL CZ 1080 6114041 Pugwash PPL CA 1080 5117689 Fort Niagara Beach PPL US 1080 594653 Siluva PPL LT 1080 3174455 Luni PPL IT 1080 3132251 Vemork PPL NO 1080 3466489 Ceilandia PPL BR 1080 4003707 Junco PPL MX 1080 273872 Houla PPL LB 1080 5511143 Rhyolite PPL US 1080 592923 Zalavas PPL LT 1080 3628488 San Carlos de Rio Negro PPLA2 VE 1080 202080 Kibeho PPL RW 1080 6545159 Monti PPLX IT 1080 4014985 Catorce PPL MX 1080 1848002 Zamami PPL JP 1072 6255076 St. Hanshaugen PPLX NO 1068 1705097 Luna PPLA3 PH 1066 744906 Kadikoey PPL TR 1062 1257847 Sagar PPL IN 1060 4384321 Dora PPL US 1060 2842516 Sachsenhausen-Nord PPLX DE 1060 4987981 Cannonsburg PPL US 1060 2657834 Aberdaron PPL GB 1060 1900433 Run PPL ID 1060 2653473 Caversham PPL GB 1060 4778721 Philomont PPL US 1060 295547 BetVeGan PPLX IL 1060 2148398 Port Stephens PPL AU 1060 5333937 Canyon PPL US 1060 4156013 Fort Pickens PPL US 1060 6545143 Ponte PPLX IT 1060 5137499 Seagate PPL US 1060 262244 Frangokastellon PPL GR 1060 2623322 Bronshoj PPLX DK 1060 6151026 Sointula PPL CA 1060 4828653 Chadwick PPL US 1060 77017 Bayhan PPLA2 YE 1060 2656435 Balquhidder PPL GB 1060 2939474 Dagstuhl PPLX DE 1060 4720393 Praha PPL US 1060 4995966 Higgins Lake PPL US 1060 4393869 Koeltztown PPL US 1060 1650801 Bagan Si Api-api PPLA2 ID 1060 477497 Uzkoye PPLX RU 1060 3446229 Trancoso PPL BR 1060 3056720 Volkovce PPL SK 1060 5056515 New Point PPL US 1060 696583 Pomortsy PPL UA 1060 5367510 Locke PPL US 1060 283862 Gillo PPLX IL 1060 6332416 Tudor City PPL US 1060 2859203 Obersalzberg PPL DE 1048 1278542 Annavaram PPL IN 1047 675518 Iosia PPLX RO 1045 2758408 Brandevoort PPLX NL 1040 5216793 Upper Black Eddy PPL US 1040 2137245 Bounlap PPL VU 1040 4700010 Indianola PPL US 1040 2176003 Betoota PPL AU 1040 6062335 Lynn Lake PPL CA 1040 2647239 Headington PPL GB 1040 5375286 Mount Signal PPL US 1040 2653690 Carrbridge PPL GB 1040 5325911 Ballarat PPL US 1040 2641935 Myddfai PPL GB 1040 2641897 Nantglyn PPL GB 1040 1239978 Kitulgala PPL LK 1040 5964606 Grand Manan PPL CA 1040 6087708 New Minas PPL CA 1040 1736696 Tuaran PPL MY 1040 5970492 Harbour Grace PPL CA 1040 2645818 Kenmore PPL GB 1040 5971372 Harrison Hot Springs PPL CA 1040 4782607 Rockville PPL US 1040 5964250 Grand Bend PPL CA 1040 5386866 Redwood Estates PPL US 1040 5893064 Barkerville PPL CA 1040 2645228 Kirkstall PPL GB 1040 2634812 Wandsworth PPLA3 GB 1040 4713444 Mumford PPL US 1040 2746445 Terhorst PPL NL 1040 732174 Dobarsko PPL BG 1040 2646700 Holt PPLA3 GB 1040 6072530 Metlakatla PPL CA 1040 2642476 Milton PPL GB 1040 315161 Esrefpasa PPLX TR 1040 4996581 Houghton Lake Heights PPL US 1040 2643224 Maentwrog PPLA3 GB 1040 762023 Plonna PPL PL 1040 193717 Kariobangi PPLX KE 1040 4215266 Penfield PPL US 1040 4529447 Aqua Park PPL US 1040 5396281 Sky Londa PPL US 1040 6325485 Charlesbourg PPL CA 1040 5098622 Green Pond PPL US 1040 2644119 Llandudno Junction PPL GB 1040 321308 Beyagac PPLA2 TR 1040 98850 An Nukhayb PPL IQ 1040 2964131 Geevagh PPL IE 1040 726501 Tatul PPL BG 1040 4797463 Arthurdale PPL US 1040 454810 Tornakalns PPLX LV 1040 2640448 Penn PPL GB 1040 2194034 Albury PPL NZ 1040 5908715 Bridgetown PPL CA 1040 5357630 Holy City PPL US 1040 2750039 Nijverdal PPL NL 1040 6619398 Lajpat Nagar PPL IN 1040 5247849 Carol Beach PPL US 1040 4769549 Lightfoot PPL US 1040 5886561 Arborg PPL CA 1040 5894954 Bathurst Inlet PPLL CA 1040 3157756 Feiring PPL NO 1040 4654776 Rugby PPL US 1040 4770973 Lucketts PPL US 1040 2640056 Porth PPLA3 GB 1040 1254176 Trimulgherry PPL IN 1040 6332482 Stuyvesant Town PPLX US 1040 2653972 Calshot PPL GB 1040 2748389 Puttershoek PPL NL 1040 4811735 Leetown PPL US 1040 4616685 Cumberland Furnace PPL US 1040 732961 Bozhentsi PPL BG 1040 5796263 Greenbank PPL US 1040 2759951 Aerdenhout PPL NL 1040 376115 Dunqulah al Qadimah PPL SD 1040 879905 Tsholotsho PPL ZW 1040 1162787 Wad PPL PK 1040 4824022 Summit Point PPL US 1040 3633415 Macuro PPL VE 1040 3574353 La Brea PPL TT 1040 6170930 Twillingate PPL CA 1040 2650442 East Fortune PPL GB 1038 99000 Al Qush PPL IQ 1038 2650585 Dysart PPL GB 1037 2644071 Llanfihangel-ar-Arth PPL GB 1035 5948682 Emo PPL CA 1035 1268013 Kannapuram PPL IN 1033 5548378 Thistle PPL US 1030 102891 Ras Tanura PPL SA 1029 3173356 Miseno PPL IT 1029 253045 Tanagra PPL GR 1028 4146428 Ave Maria PPL US 1028 2955585 Arkona PPL DE 1027 2651100 Dorchester PPL GB 1027 590637 Liiva PPLA2 EE 1026 1024693 Zumbo PPL MZ 1024 2656049 Beddgelert PPL GB 1023 1650217 Banjarbaru PPL ID 1021 5795251 Gardiner PPL US 1021 6179343 West Point Grey PPL CA 1021 3345336 Whitson PPL GB 1020 2646264 Ilsington PPL GB 1020 4835381 Greens Farms PPL US 1020 5966677 Greenwich PPLL CA 1020 1265587 Kunjpura PPL IN 1020 5097564 Elberon PPL US 1020 6178199 Wesleyville PPL CA 1020 6068627 McBride PPL CA 1020 2649716 Falmer PPL GB 1020 6147786 Silver Islet PPL CA 1020 5952555 Field PPL CA 1020 2650556 Earlestown PPL GB 1020 5938000 Depot Harbour PPL CA 1020 879853 Tuli PPL ZW 1020 347194 Tura PPL EG 1020 5901898 Birtle PPL CA 1020 2654934 Bramber PPL GB 1020 1264207 Makrai PPL IN 1020 6087575 New Germany PPL CA 1020 2650180 Egloskerry PPL GB 1020 2637535 Somerleyton PPL GB 1020 2638579 Sandhurst PPL GB 1020 6126245 Rockcliffe Park PPL CA 1020 2181602 Te Atatu PPL NZ 1020 2641601 New Passage PPL GB 1020 1273955 Chromepet PPL IN 1020 2633634 Woodlesford PPL GB 1020 5334537 Carson Hill PPL US 1020 2646896 Hillhead PPL GB 1020 5941602 Don Mills PPL CA 1020 2644308 Little Horwood PPL GB 1020 2655301 Boarstall PPL GB 1020 2961587 Santry PPL IE 1020 4945520 North Billerica PPL US 1020 5183376 Carversville PPL US 1020 3574866 Carapichaima PPL TT 1020 1906836 Magallanes PPL PH 1020 5907356 Bramalea PPL CA 1020 3994226 Ojuela PPL MX 1020 2657553 Aldenham PPL GB 1020 2648354 Goldcliff PPLA3 GB 1020 5945778 East Kildonan - Transcona PPL CA 1020 2654329 Bunessan PPL GB 1020 5258991 La Pointe PPL US 1020 6163868 The Glebe PPLX CA 1020 2649175 Fortingall PPL GB 1020 2655373 Blankney PPL GB 1020 6080782 Mount Forest PPL CA 1020 2639852 Pumpherston PPL GB 1020 5005325 Pequaming PPL US 1020 2649099 Framsden PPL GB 1020 2652682 Cockburnspath PPL GB 1020 2645398 Kinlochewe PPL GB 1020 733405 Baykalsko PPL BG 1020 2636281 Tamerton Foliot PPL GB 1020 2640787 Outhgill PPL GB 1020 3511632 Bavaro PPL DO 1020 1275913 Bhirarana PPL IN 1020 4120076 Lunenburg PPL US 1020 2655833 Berry Pomeroy PPL GB 1020 3203264 Brna PPL HR 1020 5946502 Economy PPL CA 1020 2642951 Martlesham PPL GB 1020 2645206 Kirkton of Tealing PPL GB 1020 6111843 Port Essington PPL CA 1020 6061977 Lumsden PPL CA 1020 2637211 Spondon PPL GB 1020 2637371 South Moor PPL GB 1020 2639095 Rotherfield PPL GB 1020 4562063 Wawa PPL US 1020 2639001 Rubery PPL GB 1020 6152517 Southport PPL CA 1020 2641999 Muker PPL GB 1020 2641155 Nun Monkton PPL GB 1020 4642793 Morganton PPL US 1020 5799629 Kennydale PPL US 1020 2652499 Combrook PPL GB 1020 2636924 Sticklepath PPL GB 1020 2061278 South Kalamunda PPL AU 1020 2639886 Princethorpe PPL GB 1020 4788181 Sugar Grove PPL US 1020 1268590 Kaiwara PPL IN 1020 5221745 Davisville, North Kingston PPL US 1020 2652914 Claxton PPL GB 1020 2636159 Taynuilt PPL GB 1020 2641074 Odstock PPL GB 1020 2640756 Ovingdean PPL GB 1020 998279 Haenertsburg PPL ZA 1020 1254890 Tardeo PPLX IN 1020 2640598 Parracombe PPL GB 1020 2654980 Bradmore PPL GB 1020 5927788 Corbyville PPL CA 1020 1179655 Domail PPL PK 1020 4180618 Auraria PPL US 1020 2634738 Warsash PPL GB 1020 5912876 Byng Inlet PPL CA 1020 5768511 Rockerville PPL US 1020 2223092 Oshie PPL CM 1020 5943647 Duggan PPLX CA 1020 2657881 Abberley PPL GB 1020 6175382 Wallace PPL CA 1020 6085647 Nakina PPL CA 1020 2638274 Seaton Carew PPL GB 1020 994557 Irene PPLX ZA 1020 2356197 Rollo PPL BF 1020 4359809 Kentland PPL US 1020 790546 Gorazhdec PPL XK 1020 2633787 Winterton-on-Sea PPL GB 1020 2328686 Nsugbe PPL NG 1020 3573796 Saint Augustine PPL TT 1020 5138675 Somers PPL US 1020 2640162 Pollok PPLX GB 1020 2652701 Coalport PPL GB 1020 4364816 Palmer Park PPL US 1020 6050948 Lax Kw'alaams PPL CA 1020 2646442 Hulme End PPL GB 1020 6052325 Lennoxville PPLX CA 1020 2643180 Maids Moreton PPL GB 1020 5948571 Emerson PPL CA 1020 1734742 Selandar PPL MY 1020 6066200 Margaretsville PPL CA 1020 4301825 Mouthcard PPL US 1020 2613365 Smerup PPL DK 1020 6180166 Whitbourne PPL CA 1020 126035 Bandar-e Laft PPL IR 1020 2635323 Tutbury PPL GB 1020 4941545 Lake Pleasant PPL US 1020 2644898 Langtree PPL GB 1020 2641219 North Witham PPL GB 1020 2654262 Burnmouth PPL GB 1020 1257871 Sadiya PPL IN 1020 6179873 Wheatley PPL CA 1020 4948470 Readville PPL US 1020 2655126 Botolphs PPL GB 1020 108852 Al `Udayliyah PPL SA 1020 1237519 Mabodale PPL LK 1020 2638408 Scarisbrick PPL GB 1020 2179275 Whangateau PPL NZ 1020 6159999 Sutherland PPL CA 1020 2649031 Frodesley PPL GB 1020 4974845 Peaks Island PPL US 1020 1263990 West Mambalam PPL IN 1020 5191676 Grantham PPL US 1020 5936199 Deadwood PPLL CA 1020 4761936 Great Bridge PPL US 1020 5246671 Brantwood PPL US 1020 2652231 Courteenhall PPL GB 1020 5207336 Puzzletown PPL US 1020 2651258 Dilhorne PPL GB 1020 2646281 Ightfield PPL GB 1020 994859 Inanda PPL ZA 1020 2645534 Kimmeridge PPL GB 1020 2642518 Millers Dale PPL GB 1020 983199 Lenasia PPL ZA 1020 5972152 Havelock PPL CA 1020 6154178 Springfield PPL CA 1020 4356082 Gibson Island PPL US 1020 2142653 Yalwal PPL AU 1020 2649046 Frisby on the Wreake PPL GB 1020 984185 Laudium PPL ZA 1020 4265229 Springville PPL US 1020 1102492 Zavora PPL MZ 1020 980232 Mahwelereng PPL ZA 1020 985649 KwaMashu PPL ZA 1020 4228489 Villanow PPL US 1020 2633961 Widecombe in the Moor PPL GB 1020 2642286 Moorby PPL GB 1020 5442625 Uravan PPL US 1020 4579459 Galivants Ferry PPL US 1020 4506862 Bond Hill PPL US 1020 1253576 Vadner PPL IN 1020 2634084 Whiteinch PPLX GB 1020 5572478 Table Bluff PPL US 1020 2641072 Offchurch PPL GB 1020 2651751 Cullercoats PPL GB 1020 2169624 Currumbin PPLX AU 1020 2638371 Scoraig PPL GB 1020 5959003 Gainsborough PPL CA 1020 2642740 Mentmore PPL GB 1020 2644530 Lickey End PPL GB 1020 2647037 Heslington PPLA3 GB 1020 5974031 Hensall PPL CA 1020 2637220 Spital in the Street PPL GB 1020 5014869 White Rock PPL US 1020 4991728 Eastmanville PPL US 1020 2655133 Bothal PPL GB 1020 2638401 Scartho PPL GB 1020 2649823 Ewelme PPL GB 1020 6157004 St. Louis PPL CA 1020 1735103 Batu Maung PPL MY 1020 6170171 Tungsten PPLL CA 1020 2647920 Grenoside PPL GB 1020 5347810 Fawnskin PPL US 1020 4319117 Carrollton PPL US 1020 328646 Sheh Husen PPL ET 1020 2655312 Blythburgh PPL GB 1020 5225689 Wickford PPL US 1020 6058853 Long Branch PPL CA 1020 972035 Nature's Valley PPL ZA 1020 5131585 Piseco PPL US 1020 6185120 Yale PPL CA 1020 1173958 Khawari PPL PK 1020 5955176 Foleyet PPL CA 1020 5955278 Fonthill PPL CA 1020 2638146 Shalstone PPL GB 1020 2654505 Broughton PPL GB 1020 2071271 Frankland PPL AU 1020 2653810 Cardonald PPLX GB 1020 5134310 Rondout PPL US 1020 2635414 Trumpington PPL GB 1020 2655249 Boldre PPL GB 1020 2640613 Parkend PPL GB 1020 5972374 Hawkestone PPLL CA 1020 2654036 Calbourne PPL GB 1020 5984185 Isachsen PPLL CA 1020 2652957 Clanfield PPL GB 1020 6111712 Port Dalhousie PPL CA 1020 5404814 University City PPLX US 1020 6108763 Point May PPL CA 1019 3689910 Andagoya PPL CO 1019 5192596 Hannastown PPL US 1016 1252987 Walong PPL IN 1015 2758927 Bilthoven PPL NL 1015 6104820 Pinawa PPL CA 1015 2635146 Upper Beeding PPL GB 1015 2642152 Morwenstow PPL GB 1015 3082654 Wambierzyce PPL PL 1013 2655670 Billesley PPL GB 1013 2644810 Launton PPL GB 1012 3456646 Morumbi PPLL BR 1012 764160 Nagorzany PPL PL 1012 3149879 Klepp PPL NO 1012 6173412 Vankleek Hill PPL CA 1011 2967012 Allihies PPL IE 1010 5216699 Union Water Works PPL US 1008 6153533 Spences Bridge PPL CA 1008 2652449 Connel PPL GB 1007 3574263 Lopinot PPL TT 1007 2642877 Mayfield PPL GB 1005 5102704 Pines Lake PPL US 1005 2651932 Cromdale PPL GB 1004 2517762 Fataga PPL ES 1003 1173088 Kotla Mohsin Khan PPLX PK 1002 2862419 Nikolausberg PPLX DE 1002 4370265 Saint Marys City PPL US 1001 1875993 Kijong-dong PPL KP 1001