geoname hierarchy, parent must exist

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

select parentid,childid,creationtime,createdbyuserid,type from geoname_hierarchy where not exists (select 1 from geoname where geonameid=parentid)

parentid	childid	creationtime	createdbyuserid	type