Recent reverted /24 ranges per number days reverted

SQL

SET STATEMENT max_statement_time = 30 FOR
SELECT
  ip24,
  c
FROM
  (
    SELECT
      CONCAT(ip24, '.0/24') AS ip24,
      COUNT(*) AS c
    FROM
      (
        SELECT DISTINCT
        	CAST(rc_timestamp AS DATE) AS day,
        	REGEXP_REPLACE(actor_name, '\.[0-9]+$', '') AS ip24
        FROM
          recentchanges_userindex AS 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_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
        WHERE
          TRUE
          AND rc_namespace = 0 -- main namespace
          AND rc_bot = 0 -- no bots
          AND change_tag_def.ctd_name = 'mw-reverted'
          AND actor_user IS NULL -- exclude registered users
          AND actor_name NOT LIKE '%:%' -- exclude IPv6
      ) AS q1
    GROUP BY
      ip24
  ) AS q2
WHERE c >= 2
ORDER BY
  c DESC
SQL

Checking query status...
