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