number of errors=13
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 3 VN 37 2 VN 48 2 VN 52 2 VN 56 2 VN 66 3 VN 68 2 VN 75 2 VN 79 2 VN 80 2 VN 82 3 VN 86 2 VN 91 3 VN 92