AC Gaming Weekdays

SQL

WITH ugroups AS (SELECT user_name, GROUP_CONCAT(ug_group SEPARATOR ',') AS groups
FROM user
INNER JOIN user_groups ON user.user_id = user_groups.ug_user
GROUP BY user_id)
SELECT
	ipb_address,
	actor_name,
    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.user_name = actor.actor_name
WHERE
	TRUE
		AND ipb_timestamp > "20210000000000"
		AND ipb_timestamp < "20220000000000"
ORDER BY ipb_timestamp DESC
SQL

Checking query status...
