number of errors=0
number of warnings=0
select count(*),countrycode,admincode1 from geoname where featurecode = 'PPLA' and countrycode || admincode1 not in ('ES53','PL76','NO30','NO34','NO38','NO42','NO46','NO54','IN12') group by 2,3 having count(*)>1 order by 2,3
count countrycode admincode1