number of errors=0
number of warnings=0
Group=ckgGrpWP
select countrycode,name,geonameid,population,admincode1,featurecode,relevance from geoname where relevance>10 and featureclass<>'P' and geonameid not in (8502102) and featurecode not in ('PPLC','PCLD','PCLH','PCLI','PCLIX','PCLF','PCLS','PCL','ADM1H','ADM2H','LK','ISL','RGN','MT','PK','MTS','VLC','HLL') and (admincode1 is null 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 cc2 is null and (admincode1 is null or admincode1 <>'00') and geonameid not in (4020095) order by relevance desc
[]
countrycode name geonameid population admincode1 featurecode relevance