SELECT log_type, log_action, count(*)

, min(log_timestamp), max(log_timestamp)

, min(log_id), max(log_id)

, GROUP_CONCAT(DISTINCT log_actor ORDER BY log_actor SEPARATOR ', ') AS actors

    FROM logging_userindex as l

    WHERE 

      log_actor in (388, 299, 4609988, 534, 8, 1058, 4415086, 9575, 20, 379, 513, 4257, 1321, 901, 8892, 273, 528, 2218, 4071, 9657, 229, 4198, 36514, 1668, 24, 580, 7, 211, 561)

      AND log_timestamp >= 20240101000000

      AND log_type NOT IN ('review', 'thanks')

      AND (log_action NOT IN ('delete_redir') OR log_action IS NULL)

      AND (NOT (log_type = 'spamblacklist' AND log_action = 'hit'))

GROUP BY log_type, log_action

ORDER BY log_type, log_action