Untitled query #84855

SQL

USE arwiki_p;

-- Check articles before 13 July 2024 with size less than 100
WITH article_sizes_before AS (
    SELECT page_id, page_title, page_len AS size_before
    FROM page
    WHERE page_namespace = 0
    AND page_len < 500
    AND page_id IN (
        SELECT DISTINCT rev_page
        FROM revision
        WHERE rev_timestamp < '20240713000000'
    )
),

-- Check articles on 13 July 2024 with size greater than or equal to 500
article_sizes_after AS (
    SELECT page_id, page_title, page_len AS size_after
    FROM page
    WHERE page_namespace = 0
    AND page_len >= 700
    AND page_id IN (
        SELECT DISTINCT rev_page
        FROM revision
        WHERE rev_timestamp BETWEEN '20240713000000' AND '20240713235959'
    )
)

-- Combine the results and calculate size difference
SELECT a.page_title, b.size_before, a.size_after, (a.size_after - b.size_before) AS size_difference
FROM article_sizes_before b
JOIN article_sizes_after a ON b.page_id = a.page_id
ORDER BY size_difference DESC;
SQL

Checking query status...
