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 ipblocks ON ipb_user = user_id
    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 log_params LIKE "%infinity%sitewide%" -- exclude tempblocks of people since indeffed; exclude p-blocks
	AND user_editcount >= 10000
	AND ipb_expiry = "infinity"
    AND ipb_sitewide = 1
ORDER BY 4 DESC

SQL

Checking query status...