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.25 and a.iscities15000 and b.iscities15000 and a.admincode1=b.admincode1
countrycode geonameid geonameid name admincode1 admincode1 CN 8417604 1815878 Longxing 33 33 CN 1815878 8417604 Longxing 33 33 IN 1260296 1260390 Paralakhemundi 21 21 IN 1260390 1260296 Paralakhemundi 21 21