number of errors=27
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 2775468 Hub AT 3042060 Hinterschellenberg LI 727523 Ruse BG 678031 Florica RO 732151 Dolina BG 666690 Slobozia RO 2661490 Birsfelden CH 2917699 Grenzacher Horn DE 11048501 Neuparadies CH 7521934 Buesingen am Hochrhein, Stemmer DE 3671373 Puerto Ospina CO 3652744 Puerto El Carmen de Putumayo EC 3671373 Puerto Ospina CO 3652593 Arca de Agua EC 2825429 Stuhlingen DE 6695992 Schleitheim, Oberwiesen CH 11205649 Ha Lejone LS 1005924 Eldoraigne ZA 2993458 Monaco MC 8029384 Beausoleil FR 829549 Badragii Noi MD 674660 Livenii Noi RO 1732752 Johor Bahru MY 7289739 Admiralty SG 1732752 Johor Bahru MY 1880739 Bulim SG 1732752 Johor Bahru MY 1880650 Hong Kah SG 1732752 Johor Bahru MY 1880508 Kian Teck San Estate SG 1732752 Johor Bahru MY 1880612 Kampong Bereh SG 2744715 Westerlee NL 2881448 Landwehr DE 521511 Nikol'skoye RU 10874499 Mehrabad IR 3058223 Pet'ov SK 3046187 Postenypuszta HU 3059447 Kolary SK 3043522 Ujkovar HU 303750 Nusaybin TR 11262477 `Alaya SY 303750 Nusaybin TR 164427 Jarkin SY 303750 Nusaybin TR 169587 Hilaliyah SY 5233700 Beebe Plain US 5897392 Beebe CA 3443061 Chui UY 11185615 Isolina Gomes BR 3443061 Chui UY 11185612 EuzebioIzabelino Bermudez BR 3443061 Chui UY 11185608 Isolina Gomez BR