number of errors=0
number of warnings=0
select countrycode,name,geonameid,admincode1 from geoname where countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') and featurecode='PPLA' 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')) order by countrycode
countrycode name geonameid admincode1