Archived extensions with subpages needing cleanup

SQL

SELECT
  concat(
    "* [[Template:",
    replace(srcpage.page_title, "_", " "),
    "]]"
  ) AS srctitle
FROM
  page as srcpage
  JOIN page_restrictions as srcrestrs ON srcrestrs.pr_page = srcpage.page_id
  AND srcrestrs.pr_type = "edit"
  JOIN redirect ON rd_from = srcpage.page_id
  JOIN page as dstpage ON dstpage.page_namespace = rd_namespace
  AND dstpage.page_title = rd_title
  JOIN page_restrictions as dstrestrs ON dstrestrs.pr_page = dstpage.page_id
  AND dstrestrs.pr_type = "edit"
WHERE  
  EXISTS srcrestrs
  AND srcpage.page_namespace = 10
;

SQL

Checking query status...