Untitled query #51044

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
     left join actor on actor_id = after.rev_actor
      left join page on  page_id=after.rev_page 
 where page_namespace=0
      
      order by after.rev_timestamp desc
      limit 10) -- 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...
