Untitled query #77879

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 'Articles\_for_deletion/Log/2023\_%' -- for the index
    AND page_title RLIKE '^Articles_for_deletion/Log/2023_(January|February|March|April|May|June|July|August|September|October)_(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...
