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_title`
FROM
  `page`
WHERE
  `page_title` IN (
    SELECT
    REPLACE(`log_params`, " ", "_")
    FROM
      `logging_logindex`
    WHERE
      `log_type` = "protect"
      AND `log_action` = "move_prot"
      AND `log_params` IS NOT NULL
      AND `log_namespace` = 0
  )
  AND `page_id` IN (
    SELECT
      `pr_page`
    FROM
      `page_restrictions`
    WHERE
      `pr_expiry` IS NULL
  )
  AND `page_namespace` = 0

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...