[Gweilo]

SELECT user_id, COUNT( * ) AS count
FROM tabelle
GROUP BY user_id
WHERE count > 1
ORDER BY count DESC

sowas vielleicht?