WITH RecentEdits AS (

    SELECT 

        p.page_id,

        p.page_title,

        COUNT(r.rev_id) AS recent_edit_count

    FROM page p

    JOIN revision r ON r.rev_page = p.page_id

    WHERE p.page_namespace = 0

      AND p.page_is_redirect = 0 -- Edits from 2023 onwards

    GROUP BY p.page_id

),

TopPages AS (

    SELECT 

        page_id,

        page_title,

        recent_edit_count,

        ROW_NUMBER() OVER (ORDER BY recent_edit_count DESC) AS rank

    FROM RecentEdits

)

SELECT 

    page_id,

    page_title,

    recent_edit_count

FROM TopPages

WHERE rank <= 30000

ORDER BY RAND()

LIMIT 10000;