Untitled query #78340

SQL

SELECT
  CONCAT('[[',REPLACE(page_title,'_',' '),']]') AS "WikiQuote updated article in #SheSaid 2022",
  rvmax.rev_len - NVL(rvprior.rev_len,0) "Campaign size increase",
  rvmax.rev_len "Current size",
    CONCAT( MID(rvmax.rev_timestamp,1,4),'-',MID(rvmax.rev_timestamp,5,2),'-',MID(rvmax.rev_timestamp,7,2),' ',
            MID(rvmax.rev_timestamp,9,2),':',MID(rvmax.rev_timestamp,11,2),':',MID(rvmax.rev_timestamp,13,2)) AS "Last update",
  IF(ISNULL(pp_value),pp_value,CONCAT('[[:d:',pp_value,']]')) AS "Wikidata item"
FROM
  revision rvf
    JOIN page ON rvf.rev_page=page_id
    JOIN revision rvmax ON rvf.rev_page=rvmax.rev_page
    JOIN revision rvprior ON rvf.rev_page=rvprior.rev_page
    LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'wikibase_item'
WHERE rvf.rev_id in (SELECT
                   rev_id
                 FROM
                   revision
                 WHERE 
                   rev_page in (SELECT  rev_page
                                FROM    revision
                                          JOIN comment_revision ON rev_comment_id=comment_id
                                          JOIN page ON rev_page=page_id
                                WHERE 
                                          rev_timestamp BETWEEN 20231001000000 AND 20231231999999
                                          AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
                                          AND page_namespace = 0
                                          AND page_is_redirect = 0)
                  GROUP BY rev_page
                  HAVING MIN(rev_timestamp) < 20231001000000)
AND rvmax.rev_id = (SELECT MAX(rev_id)
                    FROM   revision 
                    WHERE  rev_page=rvf.rev_page
                    AND    rev_timestamp < 20231231999999)
AND rvprior.rev_id = (SELECT MAX(rev_id)
                      FROM   revision 
                      WHERE  rev_page=rvf.rev_page
                      AND    rev_timestamp < 20231001000000 )
ORDER BY page_title ASC;
SQL

Checking query status...
