SQL
AخA
USE plwiki_p;
SELECT CONCAT("[[Wikipedysta:",user_name,"|",user_name,"]]") AS user_name, user_editcount, ug_group
FROM user
LEFT JOIN user_groups ON user_id = ug_user
WHERE user_editcount > 500
AND ug_group NOT LIKE 'sysop'
AND ug_group NOT LIKE 'editor'
AND ug_group NOT LIKE 'interface-admin'
AND ug_group NOT LIKE 'abusefilter'
AND ug_group NOT LIKE 'oversight'
AND ug_group NOT LIKE 'ipblock-exempt'
AND ug_group NOT LIKE 'accountcreator'
AND ug_group NOT LIKE 'bureaucrat'
AND ug_group NOT LIKE 'bot'
AND ug_group NOT LIKE 'checkuser'
AND ug_group NOT LIKE 'flood'
AND ug_group NOT LIKE 'flow-bot'
GROUP BY user_name
ORDER BY user_name DESC
limit 200;
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.