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 LIKE "%疫情%")
				OR page_title LIKE "%抗议%" OR page_title LIKE "%抗議%"
			) AND (page_title NOT LIKE "19%" AND page_title NOT LIKE "200%")
		) 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...