number of errors=66
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 Inn Pyaung MM PPL PPL 1322254 12207697 U To Chaung MM PPL PPLX 1464299 12208026 Daung Yat MM PPL PPL 1464323 12207640 Hpar Auk MM PPL PPL 1302848 12207671 Wea Ngeit MM PPL PPL 1464304 12208042 Wei Lan MM PPL PPL 1464316 12208049 Ye Pyar Kone MM PPL PPL 1285516 12208072 Thaung Gyi MM PPL PPL 1293963 12208016 Ka Taik Gyi MM PPL PPL 1321690 12207720 Hnee Hmoke MM PPL PPL 1324231 12207654 Zee Pyaung 1 MM PPL PPL 1283997 12208102 Htan Pin Chaung Ywar Gyi Paing MM PPL PPL 1294667 12207683 Kar Ma Bi MM PPL PPL 1321155 12207738 El Aguajito MX PPL PPL 3978899 4011320 Mi Ka Thit MM PPL PPL 1309383 12207873 Kawt Kha Lein MM PPL PPL 1319889 12207757 Mat Cha MM PPL PPL 1312694 12207859 Me Yone Gyi MM PPL PPL 1309490 12207865 Dawt Zan MM PPL PPL 1326454 12207642 Ah Naing Pun MM PPL PPL 1329185 12207578 Hpar Pein MM PPL PPL 1302830 12207673 Ku Lar Bi MM PPL PPL 1321380 12207790 Kayin Win Sein MM PPL PPL 1286122 12207779 Kawt Hlaing Ywar Gyi MM PPL PPL 1319925 12207748 Los Ojitos MX PPL PPL 9015984 9015985 Paw Khee MM PPL PPL 1328336 12207935 Hnget Pyaw Taw MM PPL PPL 1304481 12207656 Gawt Ywar Gyi MM PPL PPLX 1325959 12207648 Kat Ka Taung MM PPL PPL 1321395 12207741 Ka Toe MM PPL PPL 1321593 12207724 Wea Pa Tan MM PPL PPLX 1286374 12208043 Htaung Hmu MM PPL PPL 1464431 12207686 San Antonio de la Laguna MX PPL PPL 3987850 4020437 Ah Lu Ah Nauk Ywar Gyi MM PPL PPL 1329231 12207576 Wi Yaw Ywar Gyi MM PPL PPL 1286093 12208055 Lay Kay MM PPL PPL 1314260 12207843 Ah Yet Thi Ma MM PPL PPL 1328665 12207595 Me Baung MM PPL PPL 1309637 12207861 Shan Kyun MM PPL PPL 1297061 12207960 Ka Da MM PPL PPL 1321696 12207703 Ah Lu Gyi MM PPL PPL 1329229 12207577 Kawt Kha Mei MM PPL PPL 1319904 12207758 Shan Ywar Ka Lay MM PPL PPL 1297062 12207964 Inn Kwe MM PPL PPL 1322083 12207695 Thea Ein MM PPL PPL 1291802 12208018 Bar Bu Kone MM PPL PPL 1328641 12207612 Paing Ka Dar MM PPL PPL 1302515 12207927 Kawt Kha Ni MM PPL PPL 1319888 12207759 Da Nu MM PPL PPL 1326833 12207634 Mi Chaung Aing MM PPL PPL 1309366 12207870 Kyaik Ka Thar MM PPL PPL 1317400 12207810 Brownsville MX PPLX PPLX 3532097 13458279 Hpar Thein MM PPL PPL 1301248 12207674 Mar Lar Hpu MM PPL PPL 1312033 12207857 Kyar Inn MM PPL PPL 1319256 12207813 Chaung Kwayt MM PPL PPL 1327383 12207625 Hpa Yar Seik MM PPL PPL 1300643 12207669 Mu Yit Ka Lay MM PPL PPL 1308321 12207883 Kyoe Waing MM PPL PPL 1315701 12207832 Hpa Lat MM PPL PPL 1302378 12207663 Hpa Yar Ywar MM PPL PPL 1300766 12207670 Kun Thea MM PPL PPL 1464317 12207805 Ma Yang MM PPL PPL 1310022 12207856 Ah Dhamma Kone MM PPL PPL 1464413 12207567 La Ponderosa MX PPL PPL 9012774 9012801 Htan Pin Chaung Lay MM PPL PPL 1294666 12207682