Fork of Active high-volume enwiki editors by Uhai
This query is marked as a draft This query has been published by WhatamIdoing.

SQL

AخA
 
SELECT CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', u.user_name) AS 'User', COUNT(rc.rc_id) AS 'Edits in past 30 days', u.user_editcount AS 'Total edit count', TIMESTAMP(u.user_registration) AS 'Registered'
FROM user u
INNER JOIN actor a ON a.actor_user = u.user_id
INNER JOIN recentchanges_userindex rc ON rc.rc_actor = a.actor_id AND rc.rc_timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)
WHERE u.user_id NOT IN (
    SELECT ug.ug_user
    FROM user_groups ug
    WHERE ug_group = 'bot'
)
GROUP BY u.user_id
HAVING COUNT(rc.rc_id) >= 100
ORDER BY u.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.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...