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

SQL

use enwiktionary_p;

select
	actor_name as user,
    avg(cast(`after`.rev_len as bigint) - cast(`before`.rev_len as bigint)) as 'average size difference',
	min(cast(`after`.rev_len as bigint) - cast(`before`.rev_len as bigint)) as 'minimum size difference',
	max(cast(`after`.rev_len as bigint) - cast(`before`.rev_len as bigint)) 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
where `after`.rev_timestamp > '20180209000000'
group by `after`.rev_actor
order by avg(cast(`after`.rev_len as bigint) - cast(`before`.rev_len as bigint))
limit 200;

SQL

Checking query status...