Untitled query #78868

SQL

SELECT
    RANK() OVER (ORDER BY sl DESC) AS rank,
    aaa.actor_name,
    aaa.sl,
    MIN(revision.rev_timestamp) AS first_edit_date
FROM
    (
        SELECT
            actor_name,
            user_id,
            COUNT(*) AS sl
        FROM
            revision
        JOIN actor ON revision.rev_actor = actor.actor_id
        JOIN `user` ON actor.actor_user = user.user_id
        WHERE
            revision.rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 5 DAY, '%Y%m%d%H%i%s')
        GROUP BY
            actor_name
    ) AS aaa
JOIN revision ON aaa.user_id = revision.rev_actor
WHERE
    NOT EXISTS (
        SELECT
            *
        FROM
            user_groups
        WHERE
            user_groups.ug_user = aaa.user_id AND user_groups.ug_group = 'bot'
    )
GROUP BY
    aaa.actor_name, aaa.sl
ORDER BY
    sl DESC;
SQL

Checking query status...
