Untitled query #82537

SQL

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
  WHERE rc_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -3 DAY), '%Y%m%d%H%i%s')
  ORDER BY user_editcount ASC
)
SELECT *
FROM past_week_reviewers;
SQL

Checking query status...
