Untitled query #23461

SQL

use knwiki_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 < '20171201000000' and r.rev_timestamp > '20171031235959';
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 < '20171201000000' and r.rev_timestamp > '20171031235959';
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 < '20171201000000' and r.rev_timestamp > '20171031235959';
select user_name, user_editcount from user where user_registration < '20171201000000' and user_registration > '20171031235959' order by user_editcount;
SQL

Checking query status...
