Average, minimum, maximum edit size per user (failure)

SQL

use enwiktionary_p;

select
	actor_name as user,
    avg(`after`.rev_len - `before`.rev_len) as 'average size difference',
	min(`after`.rev_len - `before`.rev_len) as 'minimum size difference',
	max(`after`.rev_len - `before`.rev_len) as 'maximum size difference'
from revision_userindex as after
join revision as `before` on `before`.rev_id = `after`.rev_parent_id
join actor on actor_id = `before`.rev_actor
group by rev_actor
order by avg(`after`.rev_len - `before`.rev_len)
where `after`.rev_timestamp > '20180209000000'
limit 200;

SQL

Checking query status...