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