number of errors=15
number of warnings=0
select a.geonameid as pplid,a.ansiname as pplname,a.countrycode as pplcountry,b.geonameid as pplxid,b.ansiname as pplxname,b.countrycode as pplxcountry from geoname a,geoname b,geoname_hierarchy where a.geonameid=parentid and b.geonameid=childid and a.featureClass='P' and b.featurecode='PPLX' and a.countrycode<>b.countrycode order by a.countrycode,a.geonameid
pplid pplname pplcountry pplxid pplxname pplxcountry 727523 Ruse BG 678031 Florica RO 732151 Dolina BG 666690 Slobozia RO 3671373 Puerto Ospina CO 3652593 Arca de Agua EC 3671373 Puerto Ospina CO 3652744 Puerto El Carmen de Putumayo EC 11205649 Ha Lejone LS 1005924 Eldoraigne ZA 829549 Badragii Noi MD 674660 Livenii Noi RO 1732752 Johor Bahru MY 1880508 Kian Teck San Estate SG 1732752 Johor Bahru MY 1880650 Hong Kah SG 1732752 Johor Bahru MY 7289739 Admiralty SG 1732752 Johor Bahru MY 1880739 Bulim SG 1732752 Johor Bahru MY 1880612 Kampong Bereh SG 521511 Nikol'skoye RU 10874499 Mehrabad IR 3058223 Pet'ov SK 3046187 Postenypuszta HU 3059447 Kolary SK 3043522 Ujkovar HU 5233700 Beebe Plain US 5897392 Beebe CA