Query Run
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