number of errors=10
number of warnings=0
select a.countrycode,a.geonameid,b.geonameid,a.name,a.admincode1,b.admincode1 from geoname a, geoname b where a.geonameid <> b.geonameid and a.featureclass='P' and b.featureclass='P' and lower(a.name)=lower(b.name) and a.longlat<->b.longlat<0.15 and a.iscities5000 and b.iscities5000 and a.admincode1=b.admincode1 and a.geonameid not in (12157065,12157098)
countrycode geonameid geonameid name admincode1 admincode1 IN 1278802 10700431 Amgaon 16 16 IN 10700431 1278802 Amgaon 16 16 BR 6317074 3664301 Envira 04 04 BR 3664301 6317074 Envira 04 04 IN 1269850 8224305 Hatti 19 19 IN 8224305 1269850 Hatti 19 19 IN 1263692 10846528 Manjēshvar 13 13 IN 10846528 1263692 Manjēshvar 13 13 IN 10877293 10846370 Munnūru 19 19 IN 10846370 10877293 Munnūru 19 19