Untitled query #82537

SQL

WITH editors(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 sandbox}} <!-- EDIT BELOW THIS LINE -->\'')
  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 rc_timestamp DESC
)
SELECT *
FROM editors;
SQL

Checking query status...
