relevant P with Wikipedia link have valid admincode1

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 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 (1819609,12747063,12747064) order by relevance desc

[]

countrycode	name	geonameid	population	admincode1	featurecode	relevance