Untitled query #82537

SQL

WITH past_week_reviewers(pwr_name) 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 max(rc_timestamp) DESC
)
SELECT pwr_name as 'User', CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', pwr_name) as 'Contributions'
FROM past_week_reviewers;
SQL

Checking query status...
