Revisions since first reversion deletion

This query is marked as a draft This query has been published by Jdcc-berkman.

SQL

SELECT count(*)
FROM revision
JOIN page ON rev_page = page_id
#WHERE rev_timestamp >= 20090130081928 AND rev_timestamp < 20120000000000 # 167,248,276 in 1633 seconds
#WHERE rev_timestamp >= 20120000000000 AND rev_timestamp < 20140000000000 # 100126964 in 1411.49 seconds
WHERE rev_timestamp >= 20140000000000 AND rev_timestamp < 20160000000000 #  in  seconds
#WHERE rev_timestamp >= 20120000000000 AND rev_timestamp < 20150000000000 #  in  seconds
AND page_namespace IN (0, 1, 2, 3);

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...