number of errors=0
number of warnings=0
select countrycode,name,geonameid,population from geoname where countrycode not in ('EH','HK','MO','MR','SG') 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 countrycode in (select distinct countrycode from geoname where featurecode='ADM1' and admincode1<>'00') order by countrycode
exceptions: HK,SG
countrycode name geonameid population