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