zhwiki page_restrictions inf in ns 0

Fork of zhwiki page_restrictions long time in ns 0/4 by Xiplus

This query is marked as a draft This query has been published by Xiplus.

SQL

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

SQL

Checking query status...