SQL
x
SELECT
RANK() OVER (ORDER BY sl DESC) AS rank,
actor_name,
sl,
first_edit_date
FROM
(SELECT
actor_name,
user_id,
COUNT(*) AS sl,
MIN(rui.rev_timestamp) AS first_edit_date
FROM
revision
JOIN actor ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
JOIN revision_userindex rui ON revision.rev_id = rui.rev_id
WHERE
rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 5 DAY, '%Y%m%d%H%i%s')
GROUP BY
actor_name) aaa
JOIN revision ON actor_name = aaa.actor_name
ORDER BY
sl DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.