SQL
x
USE rowiktionary_p;
SELECT user_name,
user_editcount
FROM user
WHERE user_id NOT IN /* Exclude local bots. */
(SELECT ug_user
FROM user_groups
WHERE ug_group="bot")
AND user_name NOT IN
(SELECT gu_name
FROM centralauth_p.globaluser JOIN centralauth_p.localuser ON lu_name=gu_name AND lu_wiki="rowiktionary"
JOIN centralauth_p.global_user_groups ON gug_user=gu_id
WHERE gug_group="global-bot")
ORDER BY user_editcount DESC LIMIT 100;
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.