Permanently protected redirects that were protected by a move

This query is marked as a draft This query has been published by Naypta.

See https://en.wikipedia.org/wiki/Wikipedia:Village_pump_(proposals)?action=edit&section=16#Automatically_remove_protection_from_a_page_when_it_is_moved

SQL

SELECT page.page_id, page.page_title, page.page_namespace FROM page LEFT JOIN 
    (
        SELECT pr_page
        FROM page_restrictions
        WHERE pr_expiry IS NULL
    ) AS permprot ON page.page_id = permprot.page_id

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...