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