Most improved Articles on 13th July

SQL

USE arwiki_p;

WITH change_details AS (
    SELECT p.page_id, p.page_title, r.rev_id, a.actor_name,
           ABS(r.rev_len - IFNULL(pr.rev_len, 0)) AS size_change,
           r.rev_len AS new_len, IFNULL(pr.rev_len, 0) AS old_len
    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
)

SELECT page_title, actor_name, size_change, 
       ROUND((size_change / old_len) * 100, 2) AS percent_change
FROM change_details
ORDER BY size_change DESC
LIMIT 50;
SQL

Checking query status...
