Untitled query #67397

SQL

SELECT rc_id, change_tag_def.ctd_name FROM recentchanges
	LEFT JOIN (SELECT * FROM change_tag JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id WHERE change_tag_def.ctd_name = 'mw-reverted')  ON ct_rev_id = recentchanges.rc_this_oldid
	#LEFT JOIN (SELECT * FROM  change_tag_def WHERE change_tag_def.ctd_name = 'mw-reverted') AS change_tag_def  ON change_tag_def.ctd_id = change_tag.ct_tag_id
    JOIN actor ON recentchanges.rc_actor = actor.actor_id
LEFT JOIN page_restrictions on recentchanges.rc_cur_id = page_restrictions.pr_page

WHERE rc_namespace = 0
	# Get only recent rc
    AND recentchanges.rc_timestamp >= curdate() - interval 4 day
    # 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'
    AND rc_actor="17079449"
SQL

Checking query status...
