number of errors=77
number of warnings=0
Group=ckgGrpPopulation
select countrycode,name,geonameid from geoname where featurecode='PPLA' and not population >0 order by countrycode
countrycode name geonameid AI Stoney Ground 3573380 AI George Hill 3573466 AI Island Harbour 3573456 AI North Hill Village 3573420 AI Sandy Hill 11205445 AI North Side 3573418 AI South Hill Village 3573385 AI The Quarter 3573375 AI West End Village 3573364 AI Farrington 3573378 BB Welchman Hall 3373430 BB Four Cross Roads 3373877 BB Checker Hall 3373993 BS Masons Bay 3571908 BS Hard Bargain 3572233 BS Black Point 3572796 BS Governor’s Harbour 3572313 BT Lungtenzampa 10172752 CG Loango 2258375 DZ Djanet 2500275 DZ In Guezzam 2493273 FJ Ahau 2205310 GG Saint Saviour 6424194 GG Torteval 3042274 GG Castel 6692239 GG St Anne 3042289 GG Saint Andrew 6692240 GG St Martin 6696773 GH Sefwi Wiawso 2294056 GQ Djibloho 12226438 GY Fort Wellington 8314122 ID Banjarbaru 1650217 IM Ballaugh 8468983 IM Crosby 3042245 IM Port Saint Mary 3042195 IM Kirkmichael 3042220 IM Kirk Braddan 3042221 IM Ballabeg 3042267 IM Onchan 3042201 IM Bride 3042259 IM Jurby 3042224 IM Santon 3042182 IM Patrick 3042199 IM Andreas 3042271 IM Maughold 3042210 IM Lezayre 3042213 IM Ballasalla 3042264 IN Amarāvati 12465603 JE Le Hocq 10942508 KE Kathwana 11764747 KW Mubārak al Kabīr 7329411 KY Little Cayman 9294258 LV Berģi 461064 ME Petnjica 3220594 MH Taroa 4039539 MH Loen 7306521 MH Airuk 7306515 MH Enewetak 7306511 MR Arafat 9222766 MS Saint Peters 3578038 NR Yangor 2110419 NR Anibare 2110447 PA Llano Tugrí 3705678 PG Buka 8714539 PG Kurumul 2092952 PW Ngereklmadel 1559820 QA Umm Şalāl ‘Alī 289524 QA Az̧ Z̧a‘āyin 289847 SB Taro 11423653 SC La Passe 11103219 SD El Fula 11003055 UZ Amir Timur 1514027 VN Thành Phố Bà Rịa 8594709 VU Saratamata 8581458 WS Satupa‘itea 4035045 WS Safotulafai 4035117 YE Al Jabīn 401043