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 custom condition
    SUM(CASE 
            WHEN page.page_title LIKE '%Yellow%' THEN 1 
            ELSE 0 
        END) AS Yellow_edit_count,

    -- Counting "Violet" edits based on custom condition
    SUM(CASE 
            WHEN page.page_namespace = 1 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...
