USE zhwiki_p;

​

SELECT

    p.page_id,

    p.page_title

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

      AND r.rev_parent_id = 0

​

    -- 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

  AND r.rev_timestamp >= '20230601000000'  -- created on or after 2024-01-01

ORDER BY RAND()

LIMIT 10000;