Untitled query #82537

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 '%Created page with '{{User sand%')
  JOIN actor_recentchanges ON actor_id = rc_actor
  JOIN user ON user_id = actor_user
  WHERE rc_namespace = 0
    AND rc_timestamp >= @one_week
  ORDER BY user_editcount ASC
)
SELECT *
FROM past_week_reviewers;
SQL

Checking query status...
