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.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 GY 3379796 7303406 Anna Regina 16 16 GY 7303406 3379796 Anna Regina 16 16 MX 4010155 8858165 San Antonio del Coyote 07 07 MX 8858165 4010155 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 BR 13354018 3387266 Solânea 17 17 BR 3387266 13354018 Solânea 17 17