WPWP contributions 2021

SQL

WITH actors AS (
  SELECT DISTINCT(rev_actor), COUNT(*) as contributions
  FROM page
  JOIN revision ON rev_page = page_id
  JOIN comment ON rev_comment_id = comment_id
  WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND rev_timestamp > 20220701000000
  AND rev_timestamp < 20220901000000
  AND comment_text LIKE "%#WPWP%"
  GROUP BY rev_actor
)

SELECT actor_name, contributions, (CASE WHEN user_editcount > 499 THEN "Extended-confirmed" ELSE "Not extended-confirmed" END) AS "EXC Status"
FROM actors
JOIN actor ON rev_actor = actor_id
JOIN user ON actor_user = user_id
SQL

Checking query status...
