Fork of all blocks 2021 by AntiCompositeNumber
This query is marked as a draft This query has been published by Blablubbs.

SQL

AخA
 
SELECT
    ipb_address,
    actor_name,
    ipb_timestamp,
    comment_text,
    GROUP_CONCAT(ug_group SEPARATOR ", ")
FROM
    ipblocks_ipindex
    JOIN actor_ipblocks ON ipb_by_actor = actor_id
    JOIN comment_ipblocks ON ipb_reason_id = comment_id
    JOIN user_groups ON actor_user = ug_user
WHERE
    TRUE
        AND ipb_timestamp > "20210000000000"
        AND ipb_timestamp < "20220000000000"
GROUP BY ipb_id, ug_user
ORDER BY ipb_timestamp DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...