number of errors=9
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 3028808 6469844 null null null Cannes PPL 3028808 6475447 null null null Cannes PPL 2775220 6949518 2010-07-11 10:44:16.031662 null null Innsbruck PPLA 2775220 6949519 2010-07-11 10:44:16.031662 null null Innsbruck PPLA 500981 500966 null null null Rozhdestvenskoye PPL 8282099 8282093 2014-06-09 17:16:49.330379 null null Al Qatar PPL 8282141 8282144 2014-06-09 17:16:49.330379 null null Hammat al Qabil PPL 8282141 8282143 2014-06-09 17:16:49.330379 null null Hammat al Qabil PPL 3569886 3570929 null null null Schoelcher PPLA4