zhwiki: recent policy changes

SQL

USE zhwiki_p;
SELECT
rev_id, rev_parent_id, rev_timestamp,
page_id, page_title, comment_text
FROM revision
LEFT JOIN page ON revision.rev_page = page.page_id
LEFT JOIN comment ON revision.rev_comment_id = comment.comment_id
WHERE
revision.rev_timestamp > '20200320000000'
AND revision.rev_page IN
(
	SELECT page.page_id
	FROM pagelinks
	LEFT JOIN page ON pagelinks.pl_title = page.page_title AND pagelinks.pl_namespace = page.page_namespace
  	WHERE pl_from = 1608664 AND pl_namespace = 4
  		AND page_id NOT IN (
          	590741, # 嵌入包含
           	977277 # 模板文檔頁模式
        )
)
ORDER BY revision.rev_timestamp DESC
;
SQL

Checking query status...
