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 "保護日誌",

pr_expiry 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 pr_expiry >= 20190701000000

    AND page_namespace IN (0, 4)

ORDER BY pr_expiry DESC