number of errors=20
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 323776 Antalya TR ADM1 13192127 Asagi Hisar TR 535888 4521120 Township of Perry US ADM3 4508914 Clearview US 156862 4737316 Travis County US ADM2 4701458 Jollyville US 2 4737316 Travis County US ADM2 7260792 Anderson Mill (historical) 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 7260792 Anderson Mill (historical) US 2 4742143 Williamson County US ADM2 4701458 Jollyville 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