Query Run
select year(ru.rev_timestamp) y, month(ru.rev_timestamp) m,... 2 years ago
select * from page p where p.page_title in (select pl_title from pagelinks... 2 years ago