All possible articles for COVID-19 situation on zhwiki

SQL

SELECT 
	page_id,
	page_title as title,
    page_is_redirect as is_redirect,
    rev_id
    rev_timestamp
FROM page 
LEFT JOIN revision ON rev_page = page_title
WHERE (page_is_redirect = 0) AND (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%"))
ORDER BY rev_timestamp desc
GROUP BY title

SQL

Checking query status...