Untitled query #83593

SQL

SELECT rc_timestamp, user_name as 'User', CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', user_name) as 'Contributions', ipb_id
FROM recentchanges
  INNER JOIN actor_recentchanges ON rc_actor = actor_id
  INNER JOIN comment_recentchanges ON comment_id = rc_comment_id AND (comment_text LIKE '%Created page with \'{{User sandbox}} <!-- EDIT BELOW THIS LINE -->\'')
  INNER JOIN user ON actor_user = user_id
  LEFT JOIN ipblocks ON ipb_user = user_id
WHERE
  TRUE
  AND rc_timestamp >= DATE_ADD(NOW(), INTERVAL -30 DAY)
  -- AND ipb_id IS NULL
ORDER BY rc_timestamp DESC
SQL

Checking query status...
