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