Untitled query #78868

SQL

SELECT RANK() OVER (ORDER BY sl DESC) AS rank,
       actor_name,
       sl,
       MIN(rev_timestamp) AS first_edit
FROM (
    SELECT actor_name,
           user_id,
           COUNT(*) AS sl,
           MIN(rev_timestamp) AS first_edit
    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
) aaa
WHERE NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot')
GROUP BY actor_name, sl
ORDER BY sl DESC;
SQL

Checking query status...
