number of errors=2
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 MU 934754 934753 Beau Vallon 14 14 MU 934753 934754 Beau Vallon 14 14