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 @n := @n + 1 n,
  CONCAT("[https://en.wikipedia.org/w/index.php?title=", `page_title`, "&redirect=no ", `page_title`, "]") as "Redirect", `pr_level` as "Protection Level"
FROM
  `page`, (SELECT @n := 0) m
  INNER JOIN `page_restrictions` ON page_title.`page_id`=page_restrictions.`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 `n` ASC

SQL

Checking query status...