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 MX 4009984 3976535 Eldorado 25 25 MX 3976535 4009984 Eldorado 25 25 MX 4015938 8858101 Licenciado Benito Juárez 25 25 MX 8858101 4015938 Licenciado Benito Juárez 25 25