enWikiquote: #SheSaid Contributors (01-Oct-22 : 31-Dec-22)

This list is a list of #SheSaid 2022 contributors defined as people who have marked an edit contribution as #SheSaid or who created a new  article in the period which is in the scope of #SheSaid.  This includes a small number of articles that are up for deletion

SQL

SELECT 

SELECT actor_name, max(Count)
FROM
(
SELECT
  distinct actor_name AS "Account",
  0 as "Count"
FROM
  revision r
    JOIN page ON rev_page=page_id
    JOIN actor_revision ON rev_actor=actor_id
    JOIN comment_revision ON rev_comment_id=comment_id
WHERE comment_text RLIKE '.*#[Ss]he[Ss]aid.*'
AND   rev_timestamp BETWEEN 20221001000000 AND 20221231999999
group by actor_name
ORDER BY actor_name ASC;
union all
SELECT
  actor_name AS "Creator",
  count(*) "Count"
FROM
  revision r
    JOIN page ON rev_page=page_id
    JOIN actor_revision ON rev_actor=actor_id
    LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'wikibase_item'
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
                                          AND page_is_redirect = 0)
                  GROUP BY rev_page
                  HAVING MIN(rev_timestamp) >= 20221001000000)
group by actor_name
)
group by actor_name
ORDER BY actor_name ASC;

SQL

Checking query status...