Get Users with more Than 10 revisions in a given period - Quarry

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

SQL

SELECT rev_page,rev_id,rev_user,rev_timestamp,rev_sha1 FROM revision INNER JOIN 
(SELECT rev_user as user,count(rev_user) as revs_per_user FROM revision 
 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

AخA
 
SELECT rev_page,rev_id,rev_user,rev_timestamp,rev_sha1 FROM revision INNER JOIN (SELECT rev_user as user,count(rev_user) as revs_per_user FROM revision  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.

Checking query status...