select
page_title
from page
join revision
on page_latest = rev_id
where
... |
3 years ago |
select *
from page
join revision
on page_latest = rev_id
where
... |
3 years ago |
select *
from page
where
page_namespace = 6 -- file
and page_id not in... |
3 years ago |