SQL
AخA
USE plwiki_p;
SELECT user_name AS user, CONCAT("{{Lw|",user_name,"}}") AS user_name, user_editcount, ug_group, COUNT(actor_id) AS recent_user_editcount
FROM user
LEFT OUTER JOIN actor ON actor_user = user_id
LEFT OUTER JOIN revision_actor_temp ON revactor_actor = actor_id
LEFT OUTER JOIN user_groups ON ug_user = actor_user
LEFT OUTER JOIN page ON page_id = revactor_page
LEFT OUTER JOIN logging ON log_actor = actor_id
WHERE page_namespace = 0
AND actor_user IS NOT NULL
AND user_editcount > 500
AND revactor_timestamp BETWEEN 20200301000000 AND 20200601000000
AND page_namespace = 0
AND (ug_group NOT IN ('autoreview','sysop', 'editor', 'interface-admin', 'abusefilter', 'oversight', 'ipblock-exempt', 'accountcreator', 'bureaucrat', 'bot', 'checkuser', 'flood', 'flow-bot') or ug_group IS NULL)
AND log_type LIKE 'newusers'
AND log_timestamp < 20200301000000
GROUP BY user_name
HAVING recent_user_editcount > 100
ORDER BY recent_user_editcount DESC
LIMIT 300;
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.