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 CN 1529587 8521718 Bole 13 13 CN 8521718 1529587 Bole 13 13 CN 1280623 12358512 Mangshi 29 29 CN 12358512 1280623 Mangshi 29 29 IN 1258315 11903147 Rourkela 21 21 IN 11903147 1258315 Rourkela 21 21 BR 8535094 3450011 Santana 27 27 BR 3450011 8535094 Santana 27 27 CN 8054117 2034312 Ulanhot 20 20 CN 2034312 8054117 Ulanhot 20 20