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.005 and a.iscities500 and b.iscities500 and a.admincode1=b.admincode1
countrycode geonameid geonameid name admincode1 admincode1 MX 3976535 4009984 Eldorado 25 25 MX 4009984 3976535 Eldorado 25 25 MX 4015938 8858101 Licenciado Benito Juárez 25 25 MX 8858101 4015938 Licenciado Benito Juárez 25 25 RU 1492160 1492159 Shipunovo 04 04 RU 1492159 1492160 Shipunovo 04 04