number of errors=0
number of warnings=0
country=DO
Group=chkGrpShp
select distinct countrycode,level,admincode1,adminname1,admincode2,adminname2,admincode3,adminname3,admincode4,adminname4 from geoname_shape where countrycode='DO' and level=5 and not exists (select 1 from geoname where geoname.countrycode='DO' and featurecode='ADM4' and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname_shape.admincode2=geoname.admincode2 and geoname_shape.admincode3=geoname.admincode3 and geoname_shape.admincode4=geoname.admincode4) order by admincode1,admincode2,admincode3
countrycode level admincode1 adminname1 admincode2 adminname2 admincode3 adminname3 admincode4 adminname4