number of errors=14
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 8282105 8281923 2014-06-09 17:16:49.330379 null null 8282105 8281924 2014-06-09 17:16:49.330379 null null 8282105 8281926 2014-06-09 17:16:49.330379 null null 8282105 8281927 2014-06-09 17:16:49.330379 null null 8282105 8281928 2014-06-09 17:16:49.330379 null null 8282105 8281929 2014-06-09 17:16:49.330379 null null 8282099 8282094 2014-06-09 17:16:49.330379 null null 8282099 8282095 2014-06-09 17:16:49.330379 null null 8282099 8282096 2014-06-09 17:16:49.330379 null null 8282102 8282100 2014-06-09 17:16:49.330379 null null 8282102 8282101 2014-06-09 17:16:49.330379 null null 8282138 8282134 2014-06-09 17:16:49.330379 null null 8282138 8282135 2014-06-09 17:16:49.330379 null null 8282141 8282145 2014-06-09 17:16:49.330379 null null