use knwiki_p;

select concat('[[',p.page_title,']]') as Article_Name,concat('[[User:',r.rev_user_text,'|',r.rev_user_text,']]') as User_Name,p.page_len as Size from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and rev_timestamp < '20151200000000' and rev_timestamp > '20151031235959' and r.rev_page = p.page_id;

​