regions of adm3 have not adm3code

number of errors=0
number of warnings=0
Group=chkGrpHierarchy

select geonameid,name,featurecode,countrycode,admincode1,admincode2,admincode3 from geoname where featurecode in ('CST','RGN') and admincode3 is not null and geonameid in (select parentid from geoname,geoname_hierarchy where geoname.featurecode='ADM3' and childid=geoname.geonameid group by parentid having count(*)>1 )

geonameid	name	featurecode	countrycode	admincode1	admincode2	admincode3