use orwiki_p;

select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20161001000000' and r.rev_timestamp > '20160731235959';

select * from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20161001000000' and r.rev_timestamp > '20160731235959';

select sum(r.rev_len) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20161001000000' and r.rev_timestamp > '20160731235959';

select user_name, user_editcount from user where user_registration < '20161001000000' and user_registration > '20160731235959' order by user_editcount;