select r.rev_id, r.rev_timestamp, p.page_id, p.page_title, r.rev_actor,... |
10 months ago |
select r.rev_id, r.rev_timestamp, p.page_id, p.page_title, r.rev_actor,... |
10 months ago |
select *
from revision r
join page p on r.rev_page = p.page_id
where... |
10 months ago |
select max(r.rev_timestamp)
from revision r
join page p on r.rev_page =... |
10 months ago |
select max(rev_timestamp)
from revision
where rev_timestamp < 20060000000000... |
10 months ago |
select max(rev_timestamp)
from revision
where rev_timestamp < 20060000000000 |
10 months ago |
select *
from page
where page_id = 3414021
limit 100 |
10 months ago |