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.015 and a.iscities1000 and b.iscities1000 and a.admincode1=b.admincode1
countrycode geonameid geonameid name admincode1 admincode1 BR 6318032 12958550 Porto Rico do Maranhão 13 13 BR 12958550 6318032 Porto Rico do Maranhão 13 13 BR 6318338 3389186 Santo Amaro do Maranhão 13 13 BR 3389186 6318338 Santo Amaro do Maranhão 13 13