number of errors=45
number of warnings=0
Group=chkGrpUnlocode
select countrycode,geonameid,name,relevance,featurecode from geoname where iscities5000 and not exists (select 1 from UNLOCODE20241 where geoname.geonameid=UNLOCODE20241.geonameid) and featureclass='P' and relevance>20 and countrycode in (select cc from UNLOCODE20241 where geonameid is null and code<>'' group by cc having count(*)>10) order by relevance desc
countrycode geonameid name relevance featurecode FI 658225 Helsinki 39 PPLC IL 281184 Jerusalem 38 PPLA CA 5946768 Edmonton 34 PPLA BG 732770 Burgas 31 PPLA VN 1581298 Haiphong 30 PPLA MX 3998655 León de los Aldama 28 PPLA2 NG 2352778 Abuja 27 PPLC IE 6697759 South Dublin 27 PPLX GR 255274 Piraeus 27 PPLA3 IL 7498240 West Jerusalem 24 PPLX US 5133273 Queens 24 PPLA2 US 5454711 Albuquerque 24 PPLA2 LB 268743 Ra’s Bayrūt 24 PPLX TH 1150515 Surat Thani 23 PPLA US 5125771 Manhattan 23 PPLA2 KW 412800 Şabāḩ as Sālim 23 PPL TH 1152473 Lampang 23 PPLA IS 8644037 Reykjanesbær 23 PPL LB 278913 Nabatîyé et Tahta 23 PPLA IS 3415496 Keflavík 23 PPLA PH 1723510 Budta 23 PPL US 4905687 Peoria 22 PPLA2 PH 1978681 Malingao 22 PPL QA 289523 Umm Şalāl Muḩammad 22 PPL US 4158476 Hialeah 22 PPL MV 1337611 Fuvahmulah 22 PPLA RO 11048323 Sector 6 22 PPLX JP 2111149 Sendai 21 PPLA FR 2992090 Montreuil 21 PPL US 5334223 Carlsbad 21 PPL GR 261414 Kallithéa 21 PPLA3 ES 2520600 Cadiz 21 PPLA2 NZ 2185964 North Shore 21 PPLX ID 1631761 Pekanbaru 21 PPLA US 5380698 Palmdale 21 PPL US 5122520 Jamaica 21 PPL RO 11048318 Sector 2 21 PPLX US 4574324 Charleston 21 PPLA2 US 4762894 Hampton 21 PPLA2 US 4409896 Springfield 21 PPLA2 RU 1510853 Barnaul 21 PPLA US 5339111 Concord 21 PPL DE 2861650 Nürnberg 21 PPLA3 RO 11048319 Sector 3 21 PPLX IT 2525068 Catania 21 PPLA2