number of errors=9
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 2954692 2934558 null null null 2165698 2143255 2018-04-30 22:24:47.265339 null null 8282127 8281922 2014-06-09 17:16:49.330379 null null 8282127 8281925 2014-06-09 17:16:49.330379 null null 8282084 8282092 2014-06-09 17:16:49.330379 null null 8282116 8282119 2014-06-09 17:16:49.330379 null null 8282116 8282120 2014-06-09 17:16:49.330379 null null 8282139 8282131 2014-06-09 17:16:49.330379 null null 8282139 8282132 2014-06-09 17:16:49.330379 null null