number of errors=8
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 BR 6316325 3450402 Águas de Santa Bárbara 27 27 BR 3450402 6316325 Águas de Santa Bárbara 27 27 MX 4009984 3976535 Eldorado 25 25 MX 3976535 4009984 Eldorado 25 25 MX 8858101 4015938 Licenciado Benito Juárez 25 25 MX 4015938 8858101 Licenciado Benito Juárez 25 25 RU 1492159 1492160 Shipunovo 04 04 RU 1492160 1492159 Shipunovo 04 04