SELECT actor_user AS user_id

, actor_name AS wikipedysta

, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) / 1024 AS dodane_kB

, SUM(abs(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed))) / 1024 AS bezwzgl_kB

​

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 <= 20231231235959

AND parent.rev_timestamp <= 20231231235959

AND rev.rev_timestamp >= 20230101000000

AND parent.rev_timestamp >= 20230101000000

AND actor_user IS NOT NULL

GROUP BY actor_name

ORDER BY dodane_kB DESC

LIMIT 1000;