USE etwiki_p;

SELECT

  log_comment,

  COUNT(log_id)

FROM logging

WHERE log_type = 'block'

AND log_action = 'block'

AND log_timestamp > ( NOW() - INTERVAL 24 MONTH ) 

GROUP BY log_comment

ORDER BY COUNT(log_id) DESC

LIMIT 100;