contare i duplicati in mysql

[alcatraz69]

SELECT CONCAT(field2, '+', GROUP_CONCAT(field1 ORDER BY field1 SEPARATOR ',')) 
FROM tabella GROUP BY field2
ORDER BY field2

ciao