Indefs (that stuck) of users w/ ≥10000 edits on enwiki, 2021–

Fork of My blocks of users w/ ≥100 edits by Tamzin

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

SQL

SELECT actor_name, user_name, user_editcount, log_timestamp, log_id, comment_text
FROM logging
	LEFT JOIN user ON user_name = REPLACE(log_title, "_", " ")
    INNER JOIN actor ON actor_id = log_actor
    INNER JOIN comment ON comment_id = log_comment_id
WHERE log_timestamp > 20210101000000
	AND log_type = "block"
	AND log_action = "block"
	AND user_editcount >= 10000
	AND log_params LIKE "%in%finit%" -- That's right. We're fuzzy-matching this. *screams*
    AND log_params NOT LIKE '"7::restrictions"'
ORDER BY 4 DESC

SQL

Checking query status...