number of errors=18
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) order by a.countrycode,a.geonameid
delete from geoname_hierarchy where createdbyuserid is null and exists (select 1 from tmp where tmp.parentid=geoname_hierarchy.parentid and pplxid=childid);
pplid pplname pplcountry featurecode pplxid pplxname pplxcountry createdbyuserid 4737316 Travis County US ADM2 7260792 Anderson Mill (historical) US 2 4737316 Travis County US ADM2 4701458 Jollyville US 2 4737316 Travis County US ADM2 4670783 Anderson Mill US 2 4742143 Williamson County US ADM2 4670783 Anderson Mill US 2 4742143 Williamson County US ADM2 4701458 Jollyville US 2 4742143 Williamson County US ADM2 7260792 Anderson Mill (historical) US 2 5110253 Bronx County US ADM2 5116118 Eastchester US 2 5128316 Nassau County US ADM2 5126500 Meadowmere Park US 2 5133268 Queens County US ADM2 5126500 Meadowmere Park US 2 5144050 Westchester County US ADM2 5116118 Eastchester US 2 5178040 Allegheny County US ADM2 4560179 Overbrook US 2 5201756 Montgomery County US ADM2 5211741 Shawmont US 2 5201756 Montgomery County US ADM2 5209384 Ryers US 2 5205788 Philadelphia County US ADM2 5209384 Ryers US 2 5205788 Philadelphia County US ADM2 5211741 Shawmont US 2 5205788 Philadelphia County US ADM2 4560179 Overbrook US 2 5411363 Adams County US ADM2 5411719 Altura US 2 5412056 Arapahoe County US ADM2 5411719 Altura US 2