SELECT 

    LEFT(log_timestamp, 6) AS month

    , RIGHT(LEFT(min(log_timestamp), 8), 2) as min_day

    , RIGHT(LEFT(max(log_timestamp), 8), 2) as max_day

    -- , GROUP_CONCAT(DISTINCT log_type ORDER BY log_type SEPARATOR ', ') AS log_types

    -- , GROUP_CONCAT(DISTINCT log_action ORDER BY log_action SEPARATOR ', ') AS log_actions

    , GROUP_CONCAT(DISTINCT CONCAT(log_type, ':', log_action) ORDER BY log_type, log_action SEPARATOR ', ') AS type_action_pairs

    , COUNT(*) AS total

    , min(log_id) as min_id, max(log_id) as max_id

​

    ,SUM(log_type = 'delete') AS delete_count

    ,SUM(log_type = 'block') AS block_count

    ,SUM(log_type = 'protect') AS protect_count

    ,SUM(log_type = 'move') AS move_suppressredirect_count

    ,SUM(log_type = 'abusefilter') AS abusefilter_count

    ,SUM(log_type = 'contentmodel') AS contentmodel_count

    ,SUM(log_type = 'gblblock') AS gblblock_count

    ,SUM(log_type = 'managetags') AS managetags_count

    ,SUM(log_type = 'massmessage') AS massmessage_count

    ,SUM(log_type = 'newusers') AS newusers_count

    ,SUM(log_type = 'move') AS suppressredirect_count

    ,SUM(log_action = 'patrol') AS patrol_count

    ,SUM(log_action = 'rights') AS rights_count

    ,SUM(log_action = 'setmentor') AS setmentor_count

    ,SUM(log_action = 'merge') AS merge_count

FROM logging_userindex

WHERE log_actor = 24363 -- 388 MalarzBOT.admin (only del); 299 masti (varia); 7774 Cancre (only suppress)

  AND STR_TO_DATE(CONVERT(log_timestamp USING utf8), '%Y%m%d%H%i%S') >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH)

  AND (

    log_type IN ('block', 'protect', 'abusefilter', 'contentmodel', 'gblblock', 'managetags', 'newusers')

    OR log_action IN ('patrol', 'rights', 'setmentor', 'merge')

    OR (log_type = 'delete' AND (log_action IS NULL OR log_action != 'delete_redir'))

    OR (log_type = 'massmessage' AND log_action = 'send')

    OR (log_action = 'move'  AND log_params LIKE '%s:10:"5::noredir";s:1:"1"%')

  )

GROUP BY month

ORDER BY month;

​