SQL
AخA
SELECT log_timestamp,
actor_name AS blocker,
log_title AS blockee,
comment_text,
log_params
FROM logging
JOIN actor_logging ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_type = 'block' AND log_action = 'block'
AND log_params LIKE '%sitewide";b:0%'
AND log_timestamp >= '201912' -- partial blocking enabled on enwiki by Dec 2019 RFC
ORDER BY log_title ASC,
log_timestamp ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.