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 Daung Yat MM PPL PPL 1464323 12207640 U To Chaung MM PPL PPLX 1464299 12208026 Inn Pyaung MM PPL PPL 1322254 12207697 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 Me Yone Gyi MM PPL PPL 1309490 12207865 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 Mi Ka Thit MM PPL PPL 1309383 12207873 El Aguajito MX PPL PPL 3978899 4011320 Kar Ma Bi MM PPL PPL 1321155 12207738 Thaung Gyi MM PPL PPL 1293963 12208016 Kawt Kha Lein MM PPL PPL 1319889 12207757 Hpar Pein MM PPL PPL 1302830 12207673 Mat Cha MM PPL PPL 1312694 12207859 Dawt Zan MM PPL PPL 1326454 12207642 Kayin Win Sein MM PPL PPL 1286122 12207779 Ah Naing Pun MM PPL PPL 1329185 12207578 Kawt Hlaing Ywar Gyi MM PPL PPL 1319925 12207748 Ku Lar Bi MM PPL PPL 1321380 12207790 Paw Khee MM PPL PPL 1328336 12207935 Wi Yaw Ywar Gyi MM PPL PPL 1286093 12208055 Hnget Pyaw Taw MM PPL PPL 1304481 12207656 Gawt Ywar Gyi MM PPL PPLX 1325959 12207648 Htaung Hmu MM PPL PPL 1464431 12207686 Wea Pa Tan MM PPL PPLX 1286374 12208043 Kat Ka Taung MM PPL PPL 1321395 12207741 Los Ojitos MX PPL PPL 9015984 9015985 Ka Toe MM PPL PPL 1321593 12207724 Shan Kyun MM PPL PPL 1297061 12207960 San Antonio de la Laguna MX PPL PPL 3987850 4020437 Lay Kay MM PPL PPL 1314260 12207843 Me Baung MM PPL PPL 1309637 12207861 Ah Lu Ah Nauk Ywar Gyi MM PPL PPL 1329231 12207576 Ka Da MM PPL PPL 1321696 12207703 Kawt Kha Mei MM PPL PPL 1319904 12207758 Ah Yet Thi Ma MM PPL PPL 1328665 12207595 Shan Ywar Ka Lay MM PPL PPL 1297062 12207964 Thea Ein MM PPL PPL 1291802 12208018 Ah Lu Gyi MM PPL PPL 1329229 12207577 Paing Ka Dar MM PPL PPL 1302515 12207927 Bar Bu Kone MM PPL PPL 1328641 12207612 Kawt Kha Ni MM PPL PPL 1319888 12207759 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 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 Mu Yit Ka Lay MM PPL PPL 1308321 12207883 Kyoe Waing MM PPL PPL 1315701 12207832 Hpa Yar Ywar MM PPL PPL 1300766 12207670 Kun Thea MM PPL PPL 1464317 12207805 Ah Dhamma Kone MM PPL PPL 1464413 12207567 Ma Yang MM PPL PPL 1310022 12207856 Htan Pin Chaung Lay MM PPL PPL 1294666 12207682 La Ponderosa MX PPL PPL 9012774 9012801