Fork of
user editcount 1
by Zaher kadour
This query is marked as a draft
This query has been published
by Dr-Taher.
SQL
AخA
USE arwiki_p;
SELECT user_name, user_editcount FROM user
WHERE user_name NOT IN
(SELECT user_name FROM user_groups
INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
AND user_name NOT IN
(Select pl_title from pagelinks where pl_from = 3002292)
ORDER BY user_editcount DESC LIMIT 500;
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.