number of errors=0
number of warnings=0
Group=chkGrpHierarchy
select geonameid,name,featurecode,countrycode,admincode1 from geoname where featurecode='RGN' and admincode1 is not null and admincode1<>'00' and geonameid in (select parentid from geoname,geoname_hierarchy where geoname.featurecode='ADM1' and childid=geoname.geonameid group by parentid having count(*)>1 )
geonameid name featurecode countrycode admincode1