#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
    JOIN comment_revision ON ra.rev_comment_id=comment_id
    JOIN page ON ra.rev_page=page_id
    JOIN actor_revision ON ra.rev_actor=actor_id
    JOIN revision rb ON rb.rev_timestampe=(SELECT MIN(rc.rev_timestamp)
                                               FROM revision rc
                                              WHEERE rc.rev_page=page_id)                                              
WHERE 
  ra.rev_timestamp BETWEEN 20221001000000 AND 20221231999999
  AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
ORDER BY
  ra.rev_timestamp DESC;

SQL

Checking query status...