SQL
AخA
use arwiki_p;
SELECT CONCAT(actor_name) AS "User",DATE_FORMAT(user_registration, "%Y-%m-%d") as registration_date,
SUM(CASE WHEN rev_timestamp BETWEEN 20190301000000 AND 20191001000000 THEN 1 ELSE 0 END) AS recent_user_editcount,
COUNT(rev_id) AS user_editcountlive, user_editcount
FROM revision_userindex
INNER JOIN actor ON rev_actor = actor.actor_id
INNER JOIN user ON actor.actor_id = user_id
WHERE user_editcount > 500
and actor.actor_id not in (select ug_user from user_groups)
and actor.actor_id not in (select ipb_user from ipblocks where ipb_user = user_id)
GROUP BY actor_name
having recent_user_editcount > 10
ORDER BY recent_user_editcount DESC;
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.