USE zhwiki_p;

​

SELECT

    p.page_id,

    p.page_title

    MIN(r.rev_timestamp) AS creation_timestamp

FROM page p

    -- Join on the first revision so we can filter by creation date

    INNER JOIN revision r

      ON r.rev_page = p.page_id

​

    -- Must have a Simplified varianttitle

    INNER JOIN page_props props_simpl

      ON props_simpl.pp_page = p.page_id

      AND props_simpl.pp_propname = 'varianttitle-zh-hans'

​

WHERE p.page_namespace = 0            -- only articles

  AND p.page_is_redirect = 0          -- exclude redirects

GROUP BY p.page_id

HAVING creation_timestamp >= '20240101000000'  -- created on or after 2024-01-01

ORDER BY RAND()

LIMIT 10000;