Query Run
select distinct a.actor_name, p.page_title, DATE(r.rev_timestamp) from... 1 year ago
select unique a.actor_name, p.page_title, DATE(r.rev_timestamp) from... 1 year ago
select a.actor_name, p.page_title, DATE(r.rev_timestamp) from revision... 1 year ago
select a.actor_name, p.page_title, DATE(r.rev_timestamp) from revision... 1 year ago
select a.actor_name, p.page_title, r.rev_timestamp from revision r join... 1 year ago