number of errors=10
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 Sa Par Kyi MM PPL PPL 1298640 12456805 Mabendo SL PPL PPL 2406848 2406850 La Me Gyi MM PPL PPL 1314943 12456863 Juazeirinho BR PPL PPL 3397174 3397175 U Bo MM PPL PPL 1290325 12456899 Leik Pyar Ka Lay MM PPL PPL 1314333 12456833 Maung Nwet Gyi MM PPL PPL 1310083 12456824 Htee Baw Khee MM PPL PPL 1322825 12457192 War Kho Doe MM PPL PPL 1286184 12457175 Htee Ka Ne MM PPL PPL 1322783 12457524