Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
A smart kitten
.
attempt to get unblocks per month (as a raw number, and as a % of blocks made in that month? maybe?)
Toggle Highlighting
SQL
select sum(case when log_action = 'unblock' and log_timestamp > '202412' then 1 else 0 end) as 'dec24 so far', 100 * sum(case when log_action = 'unblock' and log_timestamp > '202412' then 1 else 0 end) / sum(case when log_action = 'block' and log_timestamp > '202412' then 1 else 0 end) as 'dec24 so far (% of blocks)', sum(case when log_action = 'unblock' and log_timestamp between '202411' and '202412' then 1 else 0 end) as 'nov24', 100 * `nov24` / sum(case when log_action = 'block' and log_timestamp between '202411' and '202412' then 1 else 0 end) as 'nov24 (% of blocks)', sum(case when log_action = 'unblock' and log_timestamp between '202410' and '202411' then.1 else 0 end) as 'oct24' from logging where log_type = 'block' and log_timestamp > '2024';
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...
