SELECT rev_id, page_namespace, page_title
FROM revision
LEFT JOIN page ON... |
2 years ago |
SELECT page_namespace, page_title
FROM revision
LEFT JOIN page ON rev_page =... |
2 years ago |
SELECT rev_actor, COUNT(*) AS editcount
FROM revision
LEFT JOIN page ON... |
2 years ago |