Untitled query #51043

SQL

use tewiki_p;

select
	actor_name as user,
    avg(diff) as average,
    max(diff) as maximum,
    min(diff) as minimum,
    count(*) as count
from (select
      	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 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=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 >= 2 -- minimum number of edits
order by average desc;
SQL

Checking query status...
