Revisions since first reversion deletion

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 # 100,126,964 in 1411.49 seconds
#WHERE rev_timestamp >= 20140000000000 AND rev_timestamp < 20160000000000 # 92,457,677 in 1213.81 seconds
#WHERE rev_timestamp >= 20160000000000 AND rev_timestamp < 20180000000000 # 103,025,694 in 1771.95 seconds
WHERE rev_timestamp >= 20180000000000 # 77,738,181 in 1737.76 seconds
AND page_namespace IN (0, 1, 2, 3);

# 167,248,276 + 100,126,964 + 92,457,677 + 103,025,694 + 77,738,181 = 540,596,792
SQL

Checking query status...
