WikiQuote updated articles in #SheSaid 2022 (01-Oct-22 : 31-Dec-22)

This is related to a query for new #SheSaid WikiQuote 2022 campaign articles. on English WikiQuote from  Oct 1st 2022 till 31 Dec 2022.  Identifying any individual author from this query would be problematic.  In general this list probably requires each individual article to be individually inspected.  An update might include increate in article size in the qualifying period, but that is a trickier and compute computationally expensive query probably not impossible.  However that query would still require individal article inspections.  The query is is optimised for download as a wikitable and is even better when changed to a sortable wikitable by changing class="wikitable" to class="wikitable sortable".  This looks at mainspaces article only and precisely considers the articles that have a #SheSaid in the summary in the relevant period period and excludes articles newly created in the period.

At the moment this is a draft work in progress.

SQL

SELECT
  CONCAT('[[',REPLACE(page_title,'_',' '),']]') AS "WikiQuote updated article in #SheSaid 2022"
FROM
  revision
    JOIN page ON rev_page=page_id
WHERE 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 20221001000000 AND 20221231999999
                                          AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
                                          AND page_namespace = 0)
                  GROUP BY rev_page
                  HAVING MIN(rev_timestamp) < 20221001000000)
ORDER BY page_title ASC;

SQL

Checking query status...