Fork of
Indef protected user talk pages
by Zhuyifei1999
This query is marked as a draft
This query has been published
by Anarchyte.
SQL
AخA
SELECT
CONCAT ("[[",page_title,"]]") # wikitable formatting
AS 'Redirect' FROM page
JOIN page_restrictions ON page_id = pr_page
WHERE pr_type = 'edit'
AND pr_level = 'sysop'
AND page_namespace = 0
AND page_is_redirect = 1
AND pr_expiry = 'infinity'
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.