USE svwiki_p;

​

SELECT

  comment_text,

  COUNT(*) AS uses

FROM revision_userindex

JOIN `comment` on rev_comment_id = comment_id

JOIN actor ON rev_actor = actor_id

WHERE actor_name = 'Vesihiisi'

GROUP BY comment_text

ORDER BY uses DESC

LIMIT 25;