number of errors=1
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 2947416 6941055 2010-07-11 10:44:16.031662 null null Bochum PPLA3