number of errors=0
number of warnings=0
country=DO
select countrycode,name,geonameid,admincode1,admincode2,admincode3,admincode4,admincode5,featureclass,featurecode,relevance from geoname where countrycode in ('DO') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and admincode3 is not null and admincode4 is not null and admincode5 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.admincode3=geoname.admincode3 and b.admincode4=geoname.admincode4 and b.admincode5=geoname.admincode5 and b.featurecode='ADM5' and b.countrycode in ('DO')) order by countrycode,admincode1,admincode2,admincode3,admincode4,admincode5
countrycode name geonameid admincode1 admincode2 admincode3 admincode4 admincode5 featureclass featurecode relevance