Discarded - Quarry

SQL

USE tewiki_p;
SELECT actor_name, 
	count(actor_name) as Edit_count, 
    CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS user_name, 
    SUM(abs(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed))) AS Gross_byte_count, 
    SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS nett_byte_count
FROM actor, revision rev,  revision parent, page
where actor_id = rev.rev_actor
	and parent.rev_id = rev.rev_parent_id
	and page_id = parent.rev_page
	and page_namespace = 0
    and substr(rev.rev_timestamp,1,4)="2020"
    AND actor_user IS NOT NULL
GROUP BY actor_name
ORDER BY gross_byte_count DESC
LIMIT 10;
SQL

Checking query status...
