number of errors=28
number of warnings=0
select a.name,a.countrycode,a.featurecode,b.featurecode,a.geonameid,b.geonameid from geoname a, geoname b where a.featureclass='P' and b.featureclass='P' and a.geonameid
name countrycode featurecode featurecode geonameid geonameid Hnget Pyaw Taw MM PPL PPL 1304481 12207656 Hpar Auk MM PPL PPL 1302848 12207671 Gawt Ywar Gyi MM PPL PPLX 1325959 12207648 Ah Lu Gyi MM PPL PPL 1329229 12207577 Shan Kyun MM PPL PPL 1297061 12207960 Bar Bu Kone MM PPL PPL 1328641 12207612 Shan Ywar Ka Lay MM PPL PPL 1297062 12207964 Thea Ein MM PPL PPL 1291802 12208018 Inn Kwe MM PPL PPL 1322083 12207695 Da Nu MM PPL PPL 1326833 12207634 Paing Ka Dar MM PPL PPL 1302515 12207927 Mi Chaung Aing MM PPL PPL 1309366 12207870 Mar Lar Hpu MM PPL PPL 1312033 12207857 Kyar Inn MM PPL PPL 1319256 12207813 Brownsville MX PPLX PPLX 3532097 13458279 Hpar Thein MM PPL PPL 1301248 12207674 Kyaik Ka Thar MM PPL PPL 1317400 12207810 Chaung Kwayt MM PPL PPL 1327383 12207625 Hpa Yar Seik MM PPL PPL 1300643 12207669 Hpa Lat MM PPL PPL 1302378 12207663 Mu Yit Ka Lay MM PPL PPL 1308321 12207883 Kyoe Waing MM PPL PPL 1315701 12207832 Hpa Yar Ywar MM PPL PPL 1300766 12207670 Ah Dhamma Kone MM PPL PPL 1464413 12207567 Htan Pin Chaung Lay MM PPL PPL 1294666 12207682 Ma Yang MM PPL PPL 1310022 12207856 Kun Thea MM PPL PPL 1464317 12207805 La Ponderosa MX PPL PPL 9012774 9012801