Permanently protected redirects that were protected by a move

Fork of Permanently protected redirects that were protected by a move by Naypta

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

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 DISTINCT CONCAT("[https://en.wikipedia.org/w/index.php?title=", `page_title`, "&redirect=no ", `page_title`, "]") as "Redirect", `pr_level` as "Protection Level"
FROM
  `page`
JOIN page_restrictions ON page_id = pr_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` IN (NULL, "infinity")
  )
  AND `page_namespace` = 0
  AND `page_is_redirect` = 1
  ORDER BY `page_id` ASC

SQL

Checking query status...