Recent reverts of multiple non-autoconfirmed editors

SQL

SELECT DISTINCT rc_title, rc_actor, max(rc_timestamp)
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
  LEFT JOIN user ON actor.actor_user = user.user_id
  INNER JOIN page ON recentchanges.rc_cur_id = page.page_id
  LEFT JOIN page_restrictions ON page.page_id = page_restrictions.pr_page
WHERE
  TRUE
  AND rc_namespace = 0
  AND change_tag_def.ctd_name = 'mw-reverted'
  AND (user.user_editcount < 10 OR actor.actor_user IS NULL)
  AND page_restrictions.pr_level IS NULL
  AND rc_timestamp >= DATE_ADD(NOW(), INTERVAL -24 HOUR)
GROUP BY rc_title
HAVING COUNT(DISTINCT rc_actor) >= 3
ORDER BY max(rc_timestamp)
SQL

Checking query status...
