Non respect du bandeau R3R

SQL

SELECT recentchanges.rc_title AS rc_title, WEEK(recentchanges.rc_timestamp) as week, COUNT(*) as nb_revocations
FROM recentchanges
	JOIN (select *
          FROM change_tags
          JOIN change_tag_def ON _change_tag_def_first.ctd_id = change_tag.ct_tag_id
         WHERE change_tag_def.ctd_name = 'R3R' ) AS change_tags_first ON change_tags_first.ct_rev_id = recentchanges.rc_this_oldid
	JOIN (select *
          FROM change_tags
          JOIN change_tag_def ON _change_tag_def_first.ctd_id = change_tag.ct_tag_id
         WHERE change_tag_def.ctd_name = 'mw-reverted' ) AS change_tags_second ON change_tags_second.ct_rev_id = recentchanges.rc_this_oldid
LEFT JOIN page_restrictions on recentchanges.rc_cur_id = page_restrictions.pr_page
WHERE rc_namespace = 0
    # Don't count autopatrolled reverted
    AND recentchanges.rc_patrolled != 2
    # Don't fetch already protected pages
    AND page_restrictions.pr_id IS NULL
    AND recentchanges.rc_timestamp > curdate() - interval 1 week
GROUP BY recentchanges.rc_title
HAVING MAX(recentchanges.rc_timestamp) > curdate() - interval 3 day
SQL

Checking query status...
