select count(*) from revisions join files on rev_file = file_id where rev_parent_id like 0 and rev_timestamp between '20011231230000' and '20191231225959' and file_namespace like 0 and file_is_redirect like 0

select count(r1.rev_file) from revisions r1 left outer join revisions r2 on (r1.rev_file = r2.rev_file and r1.rev_timestamp < r2.rev_timestamp) join files on r1.rev_file = file_id where r2.rev_file is NULL and r1.rev_parent_id like 0 and r1.rev_timestamp between '20011231230000' and '20191231225959' and file_namespace like 0 and file_is_redirect like 0