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

SQL

use enwiktionary_p;

select
	actor_name as user,
    avg(convert(`after`.rev_len, signed) - convert(`before`.rev_len, signed)) as 'average size difference',
	min(convert(`after`.rev_len, signed) - convert(`before`.rev_len, signed)) as 'minimum size difference',
	max(convert(`after`.rev_len, signed) - convert(`before`.rev_len, signed)) 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(convert(`after`.rev_len, signed) - convert(`before`.rev_len, signed))
limit 200;

SQL

Checking query status...