use orwiki_p;

select p.page_title,r.rev_user_text,p.page_len from revision r, page p where r.rev_parent_id = 0 and r.rev_len < 2048 and p.page_len < 2048 and p.page_namespace = 0 and p.page_is_redirect = 0 and rev_timestamp < '20171000000000' and rev_timestamp > '20161030235959'  and rev_user_text in ("Subas Chandra Rout");