all country codes used have a corresponding country entry in the DB

number of errors=0
number of warnings=0

select count(*),countrycode from geoname where (featurecode is null or featurecode<>'PCLH') and countrycode not in (select countrycode from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR') and countrycode is not null) group by countrycode having count(*)>1 order by countrycode

count	countrycode