an ADMH1 must not have a level=2 shape without active ADM1 for same adm1 code.

number of errors=0
number of warnings=0
Group=chkGrpShp

select geoname.countrycode,geoname.name,geoname.admincode1,geoname.geonameid,geoshapeid from geoname, geoname_shape where geoname.countrycode=geoname_shape.countrycode and geoname.admincode1=geoname_shape.admincode1 and level=2 and featurecode='ADM1H' and not exists (select 1 from geoname where geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname.featurecode='ADM1') order by 1,2

countrycode	name	admincode1	geonameid	geoshapeid