Untitled query #80103

SQL

SELECT *
  FROM (
    SELECT
      actor.actor_name,
      SUM(CAST(recentchanges_userindex.rc_new_len AS INT) - CAST(recentchanges_userindex.rc_old_len AS INT)) AS tdif,
    group_concat(recentchanges_userindex.rc_title) as nya
    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
SQL

Checking query status...
