Recent Changes — Excluding tags

SQL

SELECT
	rc.rc_timestamp AS "Time",
    rc.rc_title AS "Title",
    ctd.ctd_name AS "Tag name"
FROM
	recentchanges rc
		LEFT JOIN change_tag ct
        	ON rc.rc_id = ct.ct_rc_id
		LEFT JOIN change_tag_def ctd
        	ON ct.ct_tag_id = ctd.ctd_id          
WHERE
		rc.rc_timestamp >= 20210505000000
    AND rc.rc_timestamp <= 20210510000000
    AND rc.rc_source LIKE 'mw%'
    /* not interested in wikilove, please exclude tag_id 30 */
    AND (ct.ct_tag_id IS NULL OR NOT ct.ct_tag_id = 52)
    /* not interested in shouting, please exclude tag_id 54 */
    AND (ct.ct_tag_id IS NULL OR NOT ct.ct_tag_id = 220)
GROUP BY
	rc.rc_id
ORDER BY
	rc.rc_timestamp
    DESC
LIMIT 500;
SQL

Checking query status...
