All possible articles for COVID-19 situation on zhwiki

SQL

SELECT
	page_id,
    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 AS title,
	    `revision`.`rev_id` AS rev_id,
	    `revision`.`rev_timestamp` AS rev_timestamp
	FROM page
	INNER JOIN revision ON rev_page = page_title
	WHERE (page_is_redirect = 0) AND (page_title LIKE "%疫情%" AND page_title NOT LIKE "%冠状病毒病%" AND page_title NOT LIKE "%冠狀病毒病%") OR page_title LIKE "%抗议%" OR page_title LIKE "%抗議%"
	ORDER BY rev_timestamp ASC
)
WHERE 1=1;

SQL

Checking query status...