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