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 8858165 4010155 San Antonio del Coyote 07 07 MX 4010155 8858165 San Antonio del Coyote 07 07 BR 6318421 8437588 São Francisco de Assis do Piauí 20 20 BR 8437588 6318421 São Francisco de Assis do Piauí 20 20