number of errors=4
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 1258315 11903147 Rourkela 21 21 IN 11903147 1258315 Rourkela 21 21 CN 8054117 2034312 Ulanhot 20 20 CN 2034312 8054117 Ulanhot 20 20