Recent reverts of multiple non-autoconfirmed editors

SQL

SELECT DISTINCT rc_title, rc_actor
FROM recentchanges
  INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN actor ON recentchanges.rc_actor = actor.actor_id
  INNER JOIN user ON actor.actor_user = user.user_id
  INNER JOIN user_groups ON user.user_id = user_groups.ug_user
WHERE
  TRUE
  AND rc_namespace = 0
  AND change_tag_def.ctd_name = 'mw-reverted'
  AND user_groups.ug_group IS NULL
  AND rc_timestamp >= DATE_ADD(NOW(), INTERVAL -24 HOUR)
GROUP BY rc_title
HAVING COUNT(DISTINCT rc_actor) >= 3

SQL

Checking query status...