zhwiki policies and guidelines

SQL

SELECT pl_namespace, REPLACE(pl_title, '_', ' '), page_id, page_is_redirect, pr_level
FROM pagelinks
LEFT JOIN page ON pl_title = page_title AND pl_namespace = page_namespace
LEFT JOIN page_restrictions ON page_id = pr_page AND pr_type = 'edit'
WHERE pl_from = 1608664 AND pl_namespace = 4
	AND page_id NOT IN (
    	590741, # 嵌入包含
    	977277, # 模板文檔頁模式
        10690  # 机器人
    )
ORDER BY pl_title ASC

AخA
 
SELECT pl_namespace, REPLACE(pl_title, '_', ' '), page_id, page_is_redirect, pr_levelFROM pagelinksLEFT JOIN page ON pl_title = page_title AND pl_namespace = page_namespaceLEFT JOIN page_restrictions ON page_id = pr_page AND pr_type = 'edit'WHERE pl_from = 1608664 AND pl_namespace = 4    AND page_id NOT IN (        590741, # 嵌入包含        977277, # 模板文檔頁模式        10690  # 机器人    )ORDER BY pl_title ASC

SQL

Checking query status...