SELECT id,prodotto,count(*) as numero FROM tabella GROUP BY id ORDER BY numero DESC LIMIT 0,10