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.015 and a.iscities1000 and b.iscities1000 and a.admincode1=b.admincode1
countrycode geonameid geonameid name admincode1 admincode1 GE 613131 612536 Ozurgeti 65 65 GE 612536 613131 Ozurgeti 65 65 RU 1495021 1495022 Petukhovo 40 40 RU 1495022 1495021 Petukhovo 40 40 RU 477572 1544583 Uyskoye 13 13 RU 1544583 477572 Uyskoye 13 13