Files in category

SQL

SELECT DISTINCT
  page.page_title, revision.rev_timestamp, actor.actor_name
FROM
  categorylinks
  LEFT JOIN page ON categorylinks.cl_from = page.page_id
  INNER JOIN revision ON page.page_id = revision.rev_page
  LEFT JOIN actor ON revision.rev_actor = actor.actor_id
WHERE
  categorylinks.cl_to IN (
    SELECT
      cat_title
    FROM
      category
    WHERE
      cat_title LIKE '%Wiki_Loves_Living_Heritage_in_Singapore_2023%'
      AND NOT cat_title = 'Wiki_Loves_Living_Heritage_in_Singapore_2023_assets'
  )
  AND categorylinks.cl_type = 'file'
  AND revision.rev_parent_id = 0
  AND revision.rev_timestamp > 20230614160000
  AND revision.rev_timestamp < 20230715235959;
SQL

Checking query status...
