USE arwiki_p;

​

SELECT p.page_title, r.rev_id, a.actor_name, r.rev_len - IFNULL(pr.rev_len, 0) AS edit_size

FROM revision r

JOIN page p ON r.rev_page = p.page_id

LEFT JOIN revision pr ON r.rev_page = pr.rev_page AND r.rev_parent_id = pr.rev_id

JOIN actor a ON r.rev_actor = a.actor_id

WHERE r.rev_timestamp BETWEEN '20240713000000' AND '20240713235959'

AND p.page_namespace = 0

ORDER BY edit_size DESC

LIMIT 50;

​