taWS:All time Top 100 users by bytes added in NS0

SQL

USE tawikisource_p;
SELECT actor_name, actor_user,
	count(actor_name) as Edit_count, 
    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,
    SUM(abs(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed))))/count(actor_name) as bytes_per_edit,
    
    -- Counting "Yellow" edits based on tag or condition 
    SUM(CASE WHEN rev.tag = 'yellow' THEN 1 ELSE 0 END) AS Yellow_edit_count,
    -- Counting "Violet" edits based on tag or condition
    SUM(CASE WHEN rev.tag = 'violet' THEN 1 ELSE 0 END) AS Violet_edit_count
    
FROM revision rev
left join actor ON actor_id = rev.rev_actor
left JOIN revision parent
ON parent.rev_id = rev.rev_parent_id
left JOIN page
ON page_id = rev.rev_page
WHERE  
 page_namespace = 0 and
 actor_user IS NOT NULL
-- and page_namespace=0

--    and left(rev.rev_timestamp,4)=2020
GROUP BY actor_name
order by Edit_count desc
limit 300
SQL

Checking query status...
