Untitled query #80103

SQL

SELECT topmonth.actor_id, topmonth.actor_name, topmonth.tdif, GROUP_CONCAT(recentchanges.rc_title)
FROM (
  SELECT *
  FROM (
    SELECT
      actor.actor_name,
      recentchanges_userindex.rc_actor AS 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
) topmonth
JOIN recentchanges ON recentchanges.rc_actor = topmonth.actor_id
GROUP BY topmonth.actor_id;
SQL

Checking query status...
