AC Gaming Weekdays

SQL

WITH ugroups AS (SELECT actor_id, GROUP_CONCAT(ug_group SEPARATOR ',') AS ug_groups
FROM actor_ipblocks AS actor
INNER JOIN user_groups ON actor.actor_user = user_groups.ug_user
GROUP BY actor_id)
SELECT
	ipb_address,
	actor_name,
    ug_groups,
	ipb_timestamp,
	comment_text
FROM
	ipblocks
	INNER JOIN actor_ipblocks AS actor ON ipblocks.ipb_by_actor = actor.actor_id
	INNER JOIN comment_ipblocks AS comment ON ipblocks.ipb_reason_id = comment.comment_id
    INNER JOIN ugroups ON ugroups.actor_id = actor.actor_id
WHERE
	TRUE
		AND ipb_timestamp > "20210000000000"
		AND ipb_timestamp < "20220000000000"
ORDER BY ipb_timestamp DESC
SQL

Checking query status...
