Users by bytes added to articles

SQL

SELECT 
  actor_name,
  SUM(parent_rev_len - rev_len) AS bytes_added
FROM (
  SELECT
    actor_name,
    r.rev_len,
    r2.rev_len AS parent_rev_len
  FROM revision_userindex r
  JOIN revision r2
    ON r.rev_parent_id = r2.rev_id
  JOIN page
    ON r.rev_page = page_id
    AND page_namespace = 0
    AND page_is_redirect = 0
  JOIN actor_revision 
    ON r.rev_actor = actor_id
  LEFT JOIN user_groups 
    ON actor_user = ug_user
    AND ug_group = 'bot'
  WHERE
    r.rev_timestamp > '20240101000000'
    AND ug_group IS NULL
) delta
WHERE parent_rev_len > rev_len
GROUP BY actor_name
ORDER BY bytes_added DESC
SQL

Checking query status...
