Untitled query #80103

SQL

create temporary table as topmonth as
(select  * 
from 
(select
actor_name,
actor_id,
sum( cast(rc_new_len as int) - cast(rc_old_len as int)) tdif
from recentchanges_userindex
left join actor on rc_actor = actor_id
where rc_timestamp >= 20240101000000 and rc_timestamp <= 20240201000000  and rc_bot = 0 and (rc_source = 'mw.new' or rc_source='mw.edit') 
 
 group by actor_name) a 
where tdif >= 30000
order by tdif desc
);

select topmonth.actor_id, topmonth.actor_name, topmonth.tdif, group_concat(rc_title)
from topmonth join recentchanges where recentchanges.rc_actor = topmonth.actor_id
group by topmonth.actor_id;
SQL

Checking query status...
