-- block problem?

-- old = 65

SELECT log_actor, log_type, log_action

    , count(*) as cnt

    , LEFT(min(log_timestamp), 8) as min_t

    , LEFT(max(log_timestamp), 8) as max_t

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

FROM logging_userindex

WHERE log_actor IN (4609988, 677, 299, 8, 379, 7, 9575, 901, 534, 3529, 561, 2508, 24363, 1668, 244, 3068, 229, 9657, 36514, 273, 4257, 751, 808, 4415086, 1870, 510, 1197, 4198, 8892, 1156, 5544, 20, 2218, 4071, 513, 7774, 1711, 727, 1486, 4787639, 2206, 434, 10826, 1145, 1550, 1321, 211, 7750, 5507, 1099, 528, 2270, 8557, 370, 1480, 630, 516, 2644, 668, 7346, 21773, 24, 533, 664, 10951, 7592, 580, 2131, 13225, 8656, 2417, 6299, 35535, 1508, 3531, 3186, 5861, 2080, 33679, 2392, 1058, 622, 388, 7085, 14639, 1674, 7605, 538183, 17719, 3577, 157115, 1027, 5249, 416)

    AND log_action is null

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

GROUP BY log_type, log_actor, log_action