Most prolific (in bytes) HEWP newbies last 30 days

Fork of Most prolific (in bytes) HEWP newbies last 30 days by Ijon

This query is marked as a draft This query has been published by מקף.

SQL

select  actor_name, tdif
from 
(select
actor_name, actor_user,
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 >= DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 30 DAY),'%Y%m%d%H%i%s') and rc_bot = 0 and (rc_source = 'mw.new' or rc_source='mw.edit')
group by actor_name) a 
join user u on actor_user = u.user_id 
WHERE u.user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 30 DAY),'%Y%m%d%H%i%s') and tdif >= 200
order by tdif desc

SQL

Checking query status...