Untitled query #78868

SQL

SELECT RANK() 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 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')
ORDER BY sl DESC


select actor_name as 'user', date_format(min(rev_timestamp), '%Y-%m-%d %T') as 'first edit'
from revision_userindex
join actor on actor_id = rev_actor
group by rev_actor
order by min(rev_timestamp) desc
limit 10;
SQL

Checking query status...
