number of errors=11
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 Newton GB PPL PPL 13275304 13275445 Barkby GB PPL PPL 13275305 13275446 Chorley GB PPL PPL 13275290 13275444 Brinsworth GB PPL PPL 13275327 13275453 Harden GB PPL PPL 13275323 13275452 Shavington GB PPL PPL 13275307 13275449 Little Cressingham GB PPL PPL 13275287 13275442 Ripponden Wood GB PPL PPL 13275337 13275456 Strelley GB PPL PPL 13275306 13275448 Castle Gresley GB PPL PPL 13275288 13275443 North Skelton GB PPL PPL 13275334 13275454