All possible articles for COVID-19 situation on zhwiki

SQL

		SELECT 
			`page`.`page_id` AS page_id,
            `page`.`page_namespace` AS page_namespace,
            rev_page,
            `page`.`page_is_redirect` AS page_is_redirect,
		    rev_id,
		    rev_timestamp,
		FROM revision
		INNER JOIN page ON page_title = rev_page
		WHERE (page_is_redirect = 0 AND page_namespace = 0)
      		AND (
              	(rev_page LIKE "%疫情%" AND rev_page NOT LIKE "%冠状病毒病%" AND rev_page NOT LIKE "%冠狀病毒病%")
                 OR rev_page LIKE "%抗议%" OR rev_page LIKE "%抗議%"
            )
		ORDER BY rev_timestamp ASC


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 (
	) x
	GROUP BY page_id ORDER BY page_id ASC;
) x
WHERE first_rev_timestamp > 20000101000000;
SQL

Checking query status...
