Query Run
select rev_timestamp, rev_id, rev_user_text, page_title, ... 1 year ago
select floor(rev_timestamp/100000000) as yearmonth, ... 1 year ago