Fork of
Indef fully protected redirects
by Anarchyte
This query is marked as a draft
This query has been published
by Anarchyte.
SQL
AخA
SELECT
CONCAT ("{{plthnr|",page_title,"}}") # wikitable formatting
AS 'Redirect' FROM page
JOIN page_restrictions ON page_id = pr_page
WHERE pr_type = 'edit'
AND pr_level = 'autoconfirmed'
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.