Untitled query #88121

SQL

SELECT DISTINCT 
    a.actor_name,
    SUM(
        CASE WHEN r.rev_timestamp >= NOW() - INTERVAL 1 DAY THEN r.rev_len - IFNULL((SELECT DISTINCT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_id), 0) ELSE 0 END
    ) AS byte_count_24h,
    SUM(r.rev_len - IFNULL((SELECT DISTINCT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_id), 0)) AS total_byte_count
FROM revision r
INNER JOIN actor a ON r.rev_actor = a.actor_id
INNER JOIN page p ON r.rev_page = p.page_id
INNER JOIN comment on comment_id = r.rev_comment_id
WHERE p.page_namespace = 0
AND r.rev_timestamp BETWEEN 20241001000000 AND 20241201000000
GROUP BY a.actor_name
ORDER BY byte_count_24h DESC
LIMIT 20;
SQL

Checking query status...
