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 3662435 6318301 Santa Rosa do Purus 01 01 BR 6318301 3662435 Santa Rosa do Purus 01 01 BR 6318447 3408577 São João da Baliza 25 25 BR 3408577 6318447 São João da Baliza 25 25