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