SQL
AخA
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
(srcrestrs.pr_level = "sysop" or srcrestrs.pr_level = "templateeditor")
AND srcpage.page_namespace = 10
AND dstrestrs.pr_level = "extendedconfirmed"
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.