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 "疫情|抗[议議]"
				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...