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