number of errors=6
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.015 and a.iscities1000 and b.iscities1000 and a.admincode1=b.admincode1
countrycode geonameid geonameid name admincode1 admincode1 CN 8521718 1529587 Bole 13 13 CN 1529587 8521718 Bole 13 13 CN 8054117 2034312 Ulanhot 20 20 CN 2034312 8054117 Ulanhot 20 20 BR 3445301 3465813 Vera Cruz 05 05 BR 3465813 3445301 Vera Cruz 05 05