number of errors=1
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 6357060 6357060 2025-05-05 15:19:59.109476 555112