WITH RankedPages AS (

    SELECT 

        p.page_id,

        p.page_title,

        MIN(r.rev_timestamp) AS creation_timestamp,

        SUM(pv.view_count) AS total_views

    FROM page p

    JOIN revision r ON r.rev_page = p.page_id

    JOIN pageviews pv ON pv.page_id = p.page_id

    WHERE p.page_namespace = 0

      AND p.page_is_redirect = 0

    GROUP BY p.page_id

    HAVING creation_timestamp > "20220101000000"

),

TopPages AS (

    SELECT 

        page_id,

        page_title,

        total_views,

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

    FROM RankedPages

)

SELECT 

    page_id,

    page_title,

    total_views

FROM TopPages

WHERE rank <= 30000

ORDER BY RAND()

LIMIT 10000;