Recent reverts of multiple non-autoconfirmed editors

SQL

SELECT DISTINCT rc_title, rc_actor, actor_id, actor_user, ug_user
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
WHERE
  TRUE
  AND rc_namespace = 0
  AND change_tag_def.ctd_name = 'mw-reverted'
  AND user.user_editcount < 10
  AND user.user_registration > (DATE_FORMAT((NOW() - INTERVAL 4 DAY),'%Y%m%d%H%i%S'))
  AND rc_timestamp >= DATE_ADD(NOW(), INTERVAL -24 HOUR)
GROUP BY rc_title
HAVING COUNT(DISTINCT rc_actor) >= 3

SQL

Checking query status...