SQL
AخA
SELECT Concat("[[User_talk:", user_name, "]]") editor,
rev_timestamp
FROM ipblocks
JOIN user
ON ipb_user = user_id
JOIN page
ON page_title = user_name
JOIN revision
ON page_latest = rev_id
JOIN recentchanges
ON rev_id = rc_this_oldid
WHERE ipb_user != 0
AND page_namespace = 3
AND rev_user = user_id
AND rc_patrolled != 1
AND page_id NOT IN (select cl_from from categorylinks where cl_from = page_id AND cl_to = "Requests_for_unblock");
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.