#/Edits to DRV daily log pages in 2023

Edits to DRV's daily log subpages dated 2023 and later.  (The pages are dated 2023, not the edits.  That's a different question, since e.g. [[WP:Deletion review/Log/2022 December 31]]'s most recent edit was on 2023 January 10.)

For [[WP:HD#How to find out the edit count of pages with templates?]] circa 3 November 2023.

SQL

SELECT edits, page_title FROM
(
  SELECT COUNT(*) AS edits, page_title, MIN(rev_timestamp) AS ts
  FROM revision
  JOIN page ON page_id = rev_page
  WHERE page_namespace = 4 
    AND page_title LIKE 'Deletion\_review/Log/2023\_%' -- for the index
    AND page_title RLIKE '^Deletion_review/Log/2023_(January|February|March|April|May|June|July|August|September|October|November|December)_(3[01]|[12][0-9]|[1-9])$'
  GROUP BY page_title WITH ROLLUP
) sq
ORDER BY ts ASC, edits DESC; -- irritating that rollup+order by needs a subquery

SQL

Checking query status...