Get Users with more Than 10 revisions in a given period

Fork of Get Users with more Than 10 revisions in a given period by Diego (WMF)

This query is marked as a draft This query has been published by Jmorgan (WMF).

SQL

SELECT rev_page,rev_id,rev_user,rev_timestamp,rev_sha1 FROM revision_userindex INNER JOIN 
(SELECT rev_user as user,count(rev_user) as revs_per_user FROM revision_userindex 
 WHERE rev_user !=0 AND rev_timestamp >20170101000000 GROUP BY rev_user HAVING revs_per_user > 10 ) as users ON
 rev_user = users.user WHERE rev_timestamp >20170101000000  AND rev_timestamp < 20171116215052

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...