All possible articles for COVID-19 situation on zhwiki

SQL

SELECT 
	page.page_id as page_id
	page.page_title as title,
    page.page_is_redirect as is_redirect,
    revision.rev_id as rev_id
    revision.rev_timestamp as rev_timestamp
FROM page 
LEFT JOIN revision ON rev_page = page_title
WHERE (page_title LIKE "%疫情%" OR page_title LIKE "%抗议%" OR page_title LIKE "%抗議%")
    AND (page_title NOT LIKE "%冠状病毒病%" AND page_title NOT LIKE "%冠狀病毒病%" AND page_title NOT LIKE "%艾滋病%" AND page_title NOT LIKE "%麻疹%"
         AND page_title NOT LIKE "19%" AND page_title NOT LIKE "200%" AND (page_title LIKE "2019%" OR page_title NOT LIKE "201%"))
HAVING is_redirect = 0
ORDER BY rev_timestamp newer, rev_id newer
GROUP BY title

SQL

Checking query status...