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)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed)))) AS Gross_byte_count, 
    SUM(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed))) AS nett_byte_count
FROM actor
JOIN revision rev
ON actor_id = rev.rev_actor
JOIN revision parent
ON rev.rev_parent_id = parent.rev_id
JOIN page
ON page_id = parent.rev_page
WHERE 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...
