Current blocks, by expiry month and ip/user - Quarry

This query is marked as a draft This query has been published by Cryptic.

Doesn't include globally-blocked ips or globally-locked users, unless they're also locally blocked.

For a tangent at  [[WP:AN#Many blocks shouldn't be indef]] circa 1 October 2023.

SQL

SELECT CASE
         WHEN ipb_user = 0 THEN 'anon'
         ELSE 'registered'
       END AS 'anon/reg',
       CASE
         WHEN ipb_expiry = 'infinity' THEN 'infinity'
         ELSE DATE_FORMAT(ipb_expiry, '%Y %M')
       END AS 'expiry',
       COUNT(*)
FROM ipblocks
GROUP BY ipb_user = 0, LEFT(ipb_expiry, 6);

AخA
 
SELECT CASE         WHEN ipb_user = 0 THEN 'anon'         ELSE 'registered'       END AS 'anon/reg',       CASE         WHEN ipb_expiry = 'infinity' THEN 'infinity'         ELSE DATE_FORMAT(ipb_expiry, '%Y %M')       END AS 'expiry',       COUNT(*)FROM ipblocksGROUP BY ipb_user = 0, LEFT(ipb_expiry, 6);

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 Stop Query

All SQL code is licensed under CC0 License.

Checking query status...