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 Shengavit 11111027 140600 11 PPLX 11 AM Malatia-Sebastia 7670934 144100 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