All possible articles for COVID-19 situation on zhwiki

SQL

SELECT *
FROM (
	SELECT 
		page_id,
		page_title,
		COUNT(rev_id) AS rev_count,
		rev_id AS first_rev_id,
		rev_timestamp AS first_rev_timestamp
	FROM (
		SELECT 
			page_id,
			page_title,
			rev_id,
			rev_timestamp
		FROM (
			SELECT 
				page_id,
				page_title
			FROM page
			WHERE page_is_redirect = 0 AND page_namespace = 0
				AND page_title REGEXP "(新(型|)冠((状|狀)病毒|)|(严嚴)重特殊(传|傳)染性)肺炎|2019冠(状|狀)病毒(疾|)病|武(汉|漢)肺炎|[Cc][Oo][Vv][Ii][Dd](-|)19|疫情|抗议|抗議
				AND page_title NOT = "2019冠状病毒病"
				AND page_title NOT REGEXP "19[0123456789][0123456789]|200[0123456789]|201[012345678]"
		) x
		INNER JOIN revision ON rev_page = page_id
		ORDER BY rev_timestamp ASC
	) x
	GROUP BY page_id ORDER BY page_id ASC
) x
WHERE first_rev_timestamp > 20200101000000;
SQL

Checking query status...
