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 Bajíos del Pinto MX PPL 8873000 3988612 Vila AR PPL 3832833 3832583 Muruata MX PPL 9195222 3995206 Coluta MX PPL 8876464 4012184 Las Parejas AR PPL 3847933 3840222 Santa Ana de Nahola MX PPL 8860297 3522839 Banome MX PPL 8870766 9187346 San Antonio de la Laguna MX PPL 4020437 3987850 Bancos de Calitique MX PPL 8862905 9267923 Lázaro Cárdenas MX PPL 9817468 4006918 Los Hoyos MX PPL 3997664 3977411 San Blas MX PPL 3987539 3987529 Ejido Morelos MX PPL 8599123 8599122