Untitled query #67551

SQL

SELECT rc_timestamp, change_tag_def.ctd_name, WEEK(rc_timestamp) FROM recentchanges
	JOIN change_tag ON ct_rev_id = recentchanges.rc_this_oldid
	JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id
WHERE rc_title = "Europe_Écologie_Les_Verts" AND rc_namespace = 0
    # Don't count autopatrolled reverted
    AND recentchanges.rc_patrolled != 2
    # Check if they have the 'reverted' tag, which is our way of knowing if they've been revocated
	AND change_tag_def.ctd_name = 'mw-reverted'
   GROUP BY WEEK(rc_timestamp)
SQL

Checking query status...
