jawiki blocked users

SQL

SELECT
    COUNT(CASE WHEN ipb_expiry >= 20230104235959 THEN 1 END) AS time_bound_blocked,
    COUNT(CASE WHEN ipb_expiry = 'infinity' THEN 1 END) AS infinitely_blocked_all,
    COUNT(CASE WHEN ipb_expiry = 'infinity' AND comment_text REGEXP '.*sockpuppet.*' THEN 1 END) AS infinitely_blocked_sockpuppets,
    COUNT(CASE WHEN ipb_expiry = 'infinity' AND NOT comment_text REGEXP '.*sockpuppet.*' THEN 1 END) AS infinitely_blocked_others
FROM
	user
    JOIN ipblocks ON user_id = ipb_user
    JOIN comment ON  ipb_reason_id = comment_id
SQL

Checking query status...
