SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor
FROM revision AS... |
2 years ago |
SELECT DISTINCT rev_page
FROM revision
LEFT JOIN page ON rev_page =... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT COUNT(*)
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor
FROM... |
2 years ago |