number of errors=11
number of warnings=0
Group=ckgGrpWP
select countrycode,name,geonameid,population,admincode1,featurecode,relevance from geoname where isCities5000 and featurecode<>'PPLC'and (admincode1 is null or admincode1='00' or not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.featurecode='ADM1'))and i18nname like '%en.wikipedia.org%' and countrycode in (select distinct countrycode from geoname where featurecode='ADM1' and admincode1<>'00') and geonameid not in (443093,1819609,12747063,12747064) order by relevance desc
[{key=AM,number=11}]
countrycode name geonameid population admincode1 featurecode relevance AM Kentron 7670941 124200 11 PPLX 18 AM Erebuni 866152 126700 11 PPLX 13 AM Malatia-Sebastia 7670934 144100 11 PPLX 11 AM Shengavit 11111027 140600 11 PPLX 11 AM Nor Nork 866153 135700 11 PPLX 11 AM Ajapnyak 866164 115300 11 PPLX 10 AM Avan 616864 56400 11 PPLX 9 AM Kanaker-Zeytun 7647071 74300 11 PPLX 9 AM Nubarashen 616206 11700 11 PPLX 8 AM Davtashen 616758 46500 11 PPLX 8 AM Nork-Marash 866160 12000 11 PPLX 6