number of errors=0
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