Recent small edits on enwiki

SQL

SELECT user_name as 'User', CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', user_name) as 'Contributions', ipb_id as 'Blocked?'
FROM recentchanges_userindex
  INNER JOIN actor_recentchanges ON rc_actor = actor_id
  INNER JOIN user ON actor_user = user.user_id
  LEFT JOIN ipblocks ON ipb_user = user.user_id
WHERE
  TRUE
  AND ABS(rc_new_len - rc_old_len) <= 2
  AND user.user_editcount < 500
  AND rc_timestamp >= DATE_ADD(NOW(), INTERVAL -7 DAY)
  AND rc_type != 5
  -- AND ipb_id IS NULL
GROUP BY user_name
HAVING COUNT(*) >= 40
ORDER BY max(rc_timestamp) DESC
SQL

Checking query status...
