Users, editcount with an AFC review in the past week

Users who've made at least one edit in the past week in the User: or Draft: namespace with an edit summary that looks vaguely like an AFC review, their edit counts, and totals partitioned by some likely-looking cutoffs.

See query 59935 for where I got the edit summary heuristics.  Yes, they're inelegant, and slow, and likely have many false positives, and can't be used to find now-deleted reviews, but until [[WP:AFCH]] adds tags, they're about the best we can do.

For [[WP:RAQ#AfC review's 25th review]] circa 2024 February 24.

SQL

SET @one_week = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 WEEK), '%Y%m%d%H%i%s');
WITH past_week_reviewers(pwr_name, pwr_edits) AS
(
  SELECT DISTINCT actor_name, user_editcount
  FROM recentchanges
  JOIN comment_recentchanges ON comment_id = rc_comment_id AND (comment_text LIKE 'Declining submission:%' OR comment_text LIKE 'Rejecting submission:%' OR comment_text LIKE '%Publishing accepted%')
  JOIN actor_recentchanges ON actor_id = rc_actor
  JOIN user ON user_id = actor_user
  WHERE rc_namespace IN (2, 118)
    AND rc_timestamp >= @one_week
  ORDER BY user_editcount ASC
)
SELECT 'TOTAL (editcount < 50000)' AS name, SUM(CASE WHEN pwr_edits < 50000 THEN pwr_edits ELSE 0 END) AS 'edit count'
FROM past_week_reviewers
UNION
SELECT 'TOTAL (editcount < 100000)', SUM(CASE WHEN pwr_edits < 100000 THEN pwr_edits ELSE 0 END)
FROM past_week_reviewers
UNION
SELECT 'TOTAL (editcount < 300000)', SUM(CASE WHEN pwr_edits < 300000 THEN pwr_edits ELSE 0 END)
FROM past_week_reviewers
UNION
SELECT 'TOTAL', SUM(pwr_edits)
FROM past_week_reviewers
UNION
SELECT NULL, NULL
UNION
SELECT *
FROM past_week_reviewers;

SQL

Checking query status...