number of errors=2
number of warnings=0
Group=chkGrpHierarchy
select parentid,childid,geoname_hierarchy.creationtime,geoname_hierarchy.createdbyuserid,type,ansiname,featurecode from geoname_hierarchy left join geoname on geonameid=parentid where not exists (select 1 from geoname where geonameid=childid)
parentid childid creationtime createdbyuserid type ansiname featurecode 3443061 11185608 2018-04-30 22:24:47.265339 null null Chui PPL 2993458 8029384 2014-06-09 17:16:49.330379 null null Monaco PPLC