Changes pages (in and before date)

SQL

SELECT page_title from page
WHERE page_id in ( 
  SELECT rev_page from revision
  WHERE rev_page in
    (
    SELECT rev_page from revision
    where rev_timestamp >= '20240101' and rev_timestamp >= '20240630' and rev_deleted = 0
    group by rev_page
  )
  and page_namespace = 0
  and rev_timestamp < '20240101'
  and page_id not in (
    select rd_from from redirect WHERE rd_from in (
      SELECT rev_page from revision
      where rev_timestamp >= '20240101' and rev_timestamp >= '20240630' and rev_deleted = 0
      group by rev_page
    )
  )
)
ORDER BY page_title ASC
SQL

Checking query status...
