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