USE dewiki_p;

​

SELECT

    log_action,

    COUNT(log_action) AS cnt

FROM

    logging_userindex

WHERE

    log_type='block'

GROUP BY

    log_action;