number of errors=0
number of warnings=0
select countrycode,geonameid,name,admincode1,admincode2 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='ADM2' order by countrycode,name
countrycode geonameid name admincode1 admincode2