use tewiki_p;

#desc revision;

#desc page;

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 < '20140200000000' and rev_timestamp > '20131231235959' and r.rev_page = p.page_id;