zhwiki page_restrictions long time in ns 0/4

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

SQL

Checking query status...