adm2 child of populated place

number of errors=0
number of warnings=0
Group=chkGrpHierarchy

select p.countrycode,p.name,parentid,p.featurecode,p.admincode2,c.name as childname,childid from geoname p, geoname_hierarchy h, geoname c where p.geonameid=parentid and c.geonameid=childid and c.featurecode='ADM2' and p.featureclass='P' and not exists (select 1 from metropolitan_areas where parentid=city_geonameid and childid=admx_child_geonameid)

countrycode	name	parentid	featurecode	admincode2	childname	childid