number of errors=0
number of warnings=0
Group=chkGrpHierarchy
select parentid,childid,creationtime,createdbyuserid,type from geoname_hierarchy where exists (select 1 from geoname_hierarchy b where b.childid=geoname_hierarchy.parentid and b.parentid=geoname_hierarchy.childid)
parentid childid creationtime createdbyuserid type