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

SQL

SELECT
  page_title,
  page_namespace,
  actor_name,
  ra.rev_timestamp,
  comment_text,
  rb.rev_timestamp 
FROM
  revision ra,
  revision rb,
  comment_revision,
  page,
  actor_revision
WHERE 
  ra.rev_timestamp BETWEEN 20221001000000 AND 20221231999999
  AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
  AND  rb.rev_timestamp=(SELECT MIN(rc.rev_timestamp)
                           FROM revision rc
                          WHERE rc.rev_page=page_id)                                              
  AND ra.rev_comment_id=comment_id
  AND ra.rev_page=page_id
  AND actor_revision ON ra.rev_actor=actor_id
ORDER BY
  ra.rev_timestamp DESC;

SQL

Checking query status...