number of errors=1
number of warnings=0
Group=chkGrpHierarchy
select p.countrycode,p.name,parentid,p.featurecode,p.admincode2,p.population,c.name as childname,childid, c.population as cpop from geoname p, geoname_hierarchy h, geoname c where p.geonameid=parentid and c.geonameid=childid and c.featurecode='PPLA2' and p.featureclass='P' and p.featurecode not in ('PPLA','PPLC') and parentid not in(5128581,7289169) order by 1,2
countrycode name parentid featurecode admincode2 population childname childid cpop TR Habipler 746162 PPL 8521536 null Başakşehir 6947639 193750