| select r.rev_id, p.page_title, r.rev_actor, r.rev_parent_id,... |
4 years ago |
| select r.rev_id, p.page_title, r.rev_actor, r.rev_parent_id,... |
4 years ago |
| select r.rev_id, p.page_title, r.rev_actor, r.rev_parent_id,... |
4 years ago |
| describe slots; |
4 years ago |
| describe text; |
4 years ago |
| select r.rev_id, p.page_title, r.rev_actor, r.rev_parent_id, t.old_text
from... |
4 years ago |
| select * from revision r JOIN page p ON r.rev_page=p.page_id where... |
4 years ago |
| select page_id from page where page_title="Talk:Cabbage" and page_namespace=1 |
4 years ago |
| select page_id from page where page_title="Cabbage" and page_namespace=1 |
4 years ago |
| select page_id from page where page_title="Cabbage" and namespace=1 |
4 years ago |
| describe page; |
4 years ago |
|
select page_id from page where page_title="Talk:Cabbage" LIMIT 10 |
4 years ago |
| select * from revision r where r.rev_page = (select page_id from page where... |
4 years ago |
| select * from revision r LIMIT 10 |
4 years ago |
| select * from revision r JOIN page p ON r.rev_page=p.page_id WHERE... |
4 years ago |
