number of errors=1 number of warnings=0 Group=ckgGrpName
select count(*),geonameid,lower(name),namelocale,fromiso from alternatename group by 2,3,4,5 having count(*)>1
count geonameid lower namelocale fromiso 2 1848354 йокохама bg