maximal one adm1 must have code '00'.

number of errors=0
number of warnings=0

select count(*),countrycode,admincode1 from geoname where admincode1='00' and featurecode='ADM1' group by countrycode,admincode1 having count(*)>1 order by countrycode

count	countrycode	admincode1