Recent reverts of multiple non-autoconfirmed editors

SQL

SELECT DISTINCT CONCAT('https://en.wikipedia.org/w/index.php?title=', rc_title, '&action=history'), rc_actor, max(rc_timestamp)
FROM recentchanges_userindex
  INNER JOIN change_tag ON 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_recentchanges ON rc_actor = actor_id
  LEFT JOIN user ON actor_user = user.user_id
  INNER JOIN page ON 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_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) DESC
SQL

Checking query status...
