SELECT CONCAT("#") as number, actor_user AS user_id, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS user_name, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS 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 rev.rev_timestamp <= 20241231235959

AND parent.rev_timestamp <= 20241231235959

AND rev.rev_timestamp >= 20240101000000

AND parent.rev_timestamp >= 20240101000000

AND actor_user IS NOT NULL

GROUP BY actor_name

ORDER BY byte_count DESC

LIMIT 500;