number of errors=0
number of warnings=0
Group=ckgGrpWP
select countrycode,geonameid,name,admincode1,admincode2,admincode3 from geoname where not exists (select 1 from geoname adm1 where adm1.countrycode=geoname.countrycode and adm1.admincode1=geoname.admincode1 and adm1.featurecode='ADM1') and featurecode='ADM3' and i18nname like '%.wikipedia.org%' order by countrycode,name
countrycode geonameid name admincode1 admincode2 admincode3