WikiProject Participation

SQL

WITH participants AS (
  SELECT
    DISTINCT(revactor_actor) AS wikiproject_participant
  FROM revision
  INNER JOIN revision_actor_temp
    ON (rev_id = revactor_rev)
  WHERE
    rev_page = 10034790  # https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Spoken_Wikipedia/Participants
),
wikiproject_pages AS (
  SELECT
    pa_page_id AS wikiproject_pages
  FROM page_assessments
  INNER JOIN page_assessments_projects
    ON (pap_project_id = pa_project_id
        AND pap_project_title = 'Spoken Wikipedia')
  INNER JOIN page
    ON (pa_page_id = page_id
        AND page_namespace = 0)
)
SELECT
  revactor_actor,
  COUNT(revactor_rev) AS num_edits
FROM revision_actor_temp
INNER JOIN participants
  ON (revactor_actor = wikiproject_participant)
INNER JOIN revision
  ON (rev_id = revactor_rev)
INNER JOIN wikiproject_pages
  ON (rev_page = wikiproject_pages)
WHERE
  revactor_timestamp >= 20210701000000
SQL

Checking query status...
