SQL
x
USE skwiki_p;
SELECT
user_name, user_editcount, user_touched
FROM
user
WHERE
user_editcount >= 100 and
not LOWER(CONVERT(user_name USING latin1)) RLIKE '^bot|bot$|MediaWiki message delivery|CommonsDelinker'
-- @todo filter via user_groups
ORDER BY
user_editcount desc, user_name
;
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.