New test - Quarry

SQL

SELECT RANK() OVER (ORDER BY sl DESC) rank, actor_name, (bsl / (asl+1)) sl FROM
(SELECT actor_name, user_id, COUNT(IF(page_namespace = 0, TRUE, NULL)) asl, COUNT(IF(page_namespace != 0, TRUE, NULL)) bsl FROM revision
JOIN page ON rev_page = page_id
JOIN actor ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
WHERE rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 7 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
SQL

Checking query status...
