Indef protected user talk pages

Breakdown of indef protected user talk pages. The statistics show that there has been a distinct shift in admin practice over the last 10 years. The current default practice is to avoid indef protections unless there are significant related risks of disruption such as known legal issues or harassment. Raised on https://commons.wikimedia.org/wiki/Commons:Administrators%27_noticeboard#Protection_of_blocked_user_talk_pages_without_specific_cause

Using the talk page protecting admin by checking with the logging table caused problems with this SQL. It appears that the mass renaming of accounts during global SUL harmonization has made tracking back through the log problematic. The admin account shown is the admin that blocked the account but may not always be the same as the account protecting the talk page.

SQL

USE commonswiki_p;
SELECT page_title, ipb_by_text
FROM page_restrictions
INNER JOIN page
ON pr_page = page_id
INNER JOIN ipblocks
ON ipb_address = page_title
WHERE pr_type = 'edit'
AND pr_level = 'sysop'
AND pr_expiry = 'infinity'
AND ipb_expiry = 'infinity'
AND page_namespace = 3
AND ipb_timestamp < 20160000000000
AND NOT page_title LIKE '%/%'
;

SQL

Checking query status...