Untitled query #78868

SQL

WITH UserEdits AS (
    SELECT actor_name, user_id, COUNT(*) AS edit_count
    FROM revision
    JOIN actor ON rev_actor = actor_id
    JOIN `user` ON actor_user = user_id
    WHERE rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 30 DAY, '%Y%m%d%H%i%s')
    GROUP BY actor_name, user_id
)

SELECT RANK() OVER (ORDER BY edit_count DESC) AS rank,
       ue.actor_name,
       ue.edit_count,
       date_format(min(rev_timestamp), '%Y-%m-%d %T') AS first_edit
FROM UserEdits ue
JOIN revision_userindex rui ON ue.user_id = rui.rev_actor
JOIN actor ON rui.rev_actor = actor.actor_id
GROUP BY ue.actor_name, ue.user_id
ORDER BY edit_count DESC;
SQL

Checking query status...
