number of errors=3
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 6317074 8601825 2014-06-09 17:16:49.330379 null null 8430485 8602477 2014-06-09 17:16:49.330379 null null 8430485 8602480 2014-06-09 17:16:49.330379 null null