Sandbox - Quarry

SQL

WITH rc AS (
  SELECT
    MIN(rev_id) AS rev_id,
    rev_page
  FROM
    revision
  WHERE
    rev_timestamp >= 20220330000000
    AND rev_timestamp <= 20220330235959
  GROUP BY
    rev_page
),
rc_page AS (
  SELECT
    rev_id,
    page_id,
    page_namespace,
    page_title
  FROM
    page
    JOIN rc ON rev_page = page_id
    AND page_namespace IN (0, 4, 6, 10, 14, 100, 102, 118, 828)
  GROUP BY
    page_id
),
rc_page_created_info AS (
  SELECT
    MIN(revision.rev_id) AS rev_id
  FROM
    rc_page
    JOIN revision ON rc_page.page_id = revision.rev_page
)
SELECT
  page_namespace,
  page_title
FROM
  rc_page
  JOIN rc_page_created_info ON USING (rev_id)
ORDER BY
  page_namespace ASC,
  page_title ASC
SQL

Checking query status...
