USE zhwiki_p;

SELECT CONCAT("[[Special:Redirect/page/", pr_page, "|{{subst:#ifeq:", page_namespace, "|0||{{subst:ns:", page_namespace, "}}:}}", page_title, "]]") AS "頁面",

CONCAT("[{{fullurl:Special:日志/protect|page={{subst:#ifeq:", page_namespace, "|0||{{subst:ns:", page_namespace, "}}:}}", page_title, "}} 保護日誌]") AS "保護日誌"

FROM page_restrictions

LEFT JOIN page ON pr_page = page_id

WHERE pr_type = "edit"

    AND pr_level = "autoconfirmed"

    AND pr_expiry = "infinity"

    AND page_namespace = 0

ORDER BY page_title ASC