number of errors=2
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
[{key=MA,number=2}]
countrycode name geonameid population admincode1 featurecode relevance MA Ouarzazate Airport 6297217 0 08 AIRP 11 MA Errachidia 2549340 418451 08 ADM2 11