Untitled query #80103

SQL

SELECT nya.actor_id, nya.tdif, group_concat(recentchanges.rc_title)
FROM (SELECT *
  FROM (
    SELECT
      actor.actor_name,
      actor.actor_id,
      SUM(CAST(recentchanges_userindex.rc_new_len AS INT) - CAST(recentchanges_userindex.rc_old_len AS INT)) AS tdif
    FROM recentchanges_userindex
    LEFT JOIN actor ON recentchanges_userindex.rc_actor = actor.actor_id
    WHERE
      recentchanges_userindex.rc_timestamp >= 20240101000000
      AND recentchanges_userindex.rc_timestamp <= 20240201000000
      AND recentchanges_userindex.rc_bot = 0
      AND (recentchanges_userindex.rc_source = 'mw.new' OR recentchanges_userindex.rc_source = 'mw.edit')
    GROUP BY actor.actor_name
  ) a
  WHERE tdif >= 30000
  ORDER BY tdif DESC
     ) nya left join recentchanges on recentchanges.rc_actor = nya.actor_id
group by nya.actor_id
SQL

Checking query status...
