number of errors=0
number of warnings=0
select a.geonameid as pplid,a.ansiname as pplname,a.countrycode as pplcountry,a.featurecode,b.geonameid as pplxid,b.ansiname as pplxname,b.countrycode as pplxcountry,geoname_hierarchy.createdbyuserid from geoname a,geoname b,geoname_hierarchy where a.geonameid=parentid and b.geonameid=childid and a.featureClass='A' and b.featurecode='PPLX' and b.geoNameId not in (4722244) and (a.countrycode<>'US' or geoname_hierarchy.createdbyuserid<>2) order by a.countrycode,a.geonameid
pplid pplname pplcountry featurecode pplxid pplxname pplxcountry createdbyuserid