Untitled query #78868

SQL

SELECT
    RANK() OVER (ORDER BY sl DESC) AS rank,
    actor_name,
    sl,
    MIN(revision.rev_timestamp) AS first_edit_date
FROM
    (SELECT
        actor_name,
        user_id,
        COUNT(*) AS sl
    FROM
        revision
        JOIN actor ON rev_actor = actor_id
        JOIN `user` ON actor_user = user_id
    WHERE
        rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 5 DAY, '%Y%m%d%H%i%s')
    GROUP BY
        actor_name, user_id) aaa
JOIN revision_userindex ON aaa.actor_name = revision_userindex.actor_name  -- Adjust this join condition
JOIN revision ON revision_userindex.rev_id = revision.rev_id
GROUP BY
    actor_name, sl
ORDER BY
    sl DESC;
SQL

Checking query status...
