Untitled query #51043

SQL

use tewiki_p;

select
	actor_name as user,
    sum(Gross_diff) as Gross_bytes_diff,
    sum(Nett_diff) as Gross_bytes_diff,
    count(*) as count
from (select
      abs(cast(after.rev_len as signed)
              - if(before.rev_len is null, 0, cast(before.rev_len as signed))) -- If before.rev_len is null, this is a page creation.
      		as Gross_diff,
      cast(after.rev_len as signed)
          - if(before.rev_len is null, 0, cast(before.rev_len as signed)) -- If before.rev_len is null, this is a page creation.
      		as nett_diff,
      
        actor_name
      from revision as after
      left join revision as `before`
      	on before.rev_id = after.rev_parent_id
      join actor on actor_id = after.rev_actor
      join page on  page_id=after.rev_page 
 where page_namespace=0
      
      order by after.rev_timestamp desc
      limit 10000) -- total number of recent edits to examine
      as diffs
where actor_user is not null -- Uncomment this to remove IP users.
group by actor_name
having count >= 10 -- minimum number of edits
order by average desc;
SQL

Checking query status...
