Untitled query #72273

SQL

SET @rev = (SELECT MIN(rev_id)
            FROM revision
            WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s"));
SELECT user_name, edit_count, user_registration, ug_group
FROM (
  SELECT user_name, COUNT(*) as edit_count, user_registration, ug_group, ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS row_num
  FROM revision_userindex
  JOIN actor ON actor.actor_id = revision_userindex.rev_actor
  JOIN user u ON u.user_id = actor.actor_user
  LEFT JOIN user_groups ON user_groups.ug_user = u.user_id
  WHERE u.user_name IS NOT NULL
  GROUP BY user_name
) AS t
WHERE row_num <= 25
ORDER BY edit_count DESC;
SQL

Checking query status...
