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 BR 6317719 3467878 Nova Campina 27 27 BR 3467878 6317719 Nova Campina 27 27 BR 6317721 3456186 Nova Canaã Paulista 27 27 BR 3456186 6317721 Nova Canaã Paulista 27 27 BR 3451336 6318128 Ribeirão do Sul 27 27 BR 6318128 3451336 Ribeirão do Sul 27 27