number of errors=13
number of warnings=0
select a.name,a.countrycode,a.featurecode,a.geonameid,b.geonameid from geoname a, geoname b, geoname_bbox bb where a.featureclass='P' and b.featureclass='P' and a.geonameid=bb.geonameid and accuracylevel=10 and st_within(b.geography::geometry,wkb_geometry) and a.geonameid<>b.geonameid and lower(a.name)=lower(b.name)
name countrycode featurecode geonameid geonameid Las Parejas AR PPL 3847933 3840222 Muruata MX PPL 9195222 3995206 Vila AR PPL 3832833 3832583 Bajíos del Pinto MX PPL 8873000 3988612 Banome MX PPL 8870766 9187346 Los Hoyos MX PPL 3997664 3977411 San Antonio de la Laguna MX PPL 4020437 3987850 Coluta MX PPL 8876464 4012184 Santa Ana de Nahola MX PPL 8860297 3522839 Bancos de Calitique MX PPL 8862905 9267923 Lázaro Cárdenas MX PPL 9817468 4006918 Ejido Morelos MX PPL 8599123 8599122 San Blas MX PPL 3987539 3987529