Untitled query #75134

SQL

SELECT ROW_NUMBER() OVER (ORDER BY sl DESC) rank, actor_name, sl FROM
(SELECT actor_name, user_id, COUNT(*) sl FROM revision
JOIN actor ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
WHERE rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 600 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')
ORDER BY sl DESC

AخA
 
SELECT ROW_NUMBER() OVER (ORDER BY sl DESC) rank, actor_name, sl FROM(SELECT actor_name, user_id, COUNT(*) sl FROM revisionJOIN actor ON rev_actor = actor_idJOIN `user` ON actor_user = user_idWHERE rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 600 DAY, '%Y%m%d%H%i%s')GROUP BY actor_name) aaaWHERE NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot')ORDER BY sl DESC

SQL

Checking query status...