Top Wikipedia User by Bytecounts [Verify]

SQL

set @target = 'Lofrida';
set @start = 20210501000000;
set @end = 20210601000000;

select
actor_name, 
sum(cast(rc_new_len as int) - cast(rc_old_len as int)) as 'total diff'
from recentchanges_userindex
left join actor on rc_actor = actor_id
where rc_timestamp >= @start and rc_timestamp <= @end and rc_bot = 0 and (rc_source = 'mw.new' or rc_source='mw.edit') 
and actor_name = @target;

select
actor_name, rc_title,
cast(rc_new_len as int) - cast(rc_old_len as int) as 'total diff'
from recentchanges_userindex
left join actor on rc_actor = actor_id
where rc_timestamp >= @start and rc_timestamp <= @end and rc_bot = 0 and (rc_source = 'mw.new' or rc_source='mw.edit') 
and actor_name = @target
SQL

Checking query status...
