number of errors=0
number of warnings=0
Group=chkGrpShp
select countrycode,featurecode,geonameid from geoname where featurecode='ADM5H' and not exists (select 1 from geoname_shape where geoname.countrycode=geoname_shape.countrycode and level=6 and st_within(geography::geometry,wkb_geometry)) and exists (select 1 from geoname_shape where level=6 and geoname_shape.countrycode=geoname.countrycode) order by 1
countrycode featurecode geonameid