#SheSaid on English Wikiquote from Oct 1st 2022 till 31 Dec

SQL

SELECT
  page_title,
  actor_name,
  MIN(rev_timestamp)
FROM
  revision
    JOIN page ON rev_page=page_id
    JOIN actor_revision ON rev_actor=actor_id
WHERE 
      page_namespace = 0
  AND rev_page in (SELECT  page_id
                    FROM
                      revision
                      JOIN comment_revision ON rev_comment_id=comment_id
                      JOIN page ON rev_page=page_id
                   WHERE 
                     rev_timestamp BETWEEN 20221001000000 AND 20221231999999
                     AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
                     AND page_namespace = 0)
group by page_title, actor_name
having MIN(rev_timestamp) > 20221001000000
order by rev_timestamp DESC;

SQL

Checking query status...