SELECT page_namespace, page_title, COUNT(rev_id) AS num_revisions
FROM... |
8 years ago |
SELECT page_namespace, page_title, COUNT(rev_id)
FROM page
JOIN... |
8 years ago |
SELECT page_namespace, page_title, COUNT(rev_id)
JOIN revision
ON rev_page =... |
8 years ago |
SELECT page_namespace, page_title, COUNT(rev_id)
JOIN revision
WHERE... |
8 years ago |