select count(*) from revision join file on rev_file = file_id where rev_parent_id like 0 and rev_timestamp between '20161231230000' and '20171231225959' and file_namespace like 0 and file_is_redirect like 0

select count(r1.rev_file) from revision r1 left outer join revision r2 on (r1.rev_file = r2.rev_file and r1.rev_timestamp < r2.rev_timestamp) join file on r1.rev_file = file_id where r2.rev_file is NULL and file_is_redirect like 0 and file_namespace like 0 and r1.rev_parent_id like 0