number of errors=8
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 GH 13275281 2301245 Ahwiaa 02 02 GH 2301245 13275281 Ahwiaa 02 02 MX 4015938 8858101 Licenciado Benito Juárez 25 25 MX 8858101 4015938 Licenciado Benito Juárez 25 25 CN 1815878 8417604 Longxing 33 33 CN 8417604 1815878 Longxing 33 33 CN 13308708 1796376 Shajing 30 30 CN 1796376 13308708 Shajing 30 30