Recent warnings to extended confirmed users from RedWarn users

SQL

SELECT
	`rc_this_oldid` AS "Diff",
	`actor_name` AS "Perfomer",
    `user_name` AS "Target",
    `comment_text` AS "Comment",
    IF((SELECT COUNT(*) FROM `change_tag` rv WHERE rv.`ct_rev_id` = `rc_this_oldid` AND rv.`ct_tag_id` = 590), "Y", "") AS "Reverted?"
FROM `recentchanges`
JOIN `comment` ON `rc_comment_id` = `comment_id`
JOIN `actor_recentchanges` ON `rc_actor` = `actor_id`
RIGHT JOIN `user` ON `rc_title` = `user_name`
RIGHT JOIN `user_groups` ON (`user_id` = `ug_user` AND `ug_group` = "extendedconfirmed")
RIGHT JOIN `change_tag` rw ON (rw.`ct_rev_id` = `rc_this_oldid` AND rw.`ct_tag_id` = 577)
WHERE
	`rc_namespace` = 3
    AND `rc_type` = 0
    AND `rc_timestamp` > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -7 DAY), "%Y%m%d%H%i%s")
    AND (
      `comment_text` LIKE "Note:%" 
      OR `comment_text` LIKE "Caution:%" 
      OR `comment_text` LIKE "Warning:%"
      OR `comment_text` LIKE "Final warning:%"
    );
SQL

Checking query status...
