SELECT rev_page, COUNT(rev_id) AS editcounts, page_title
FROM revision
JOIN... |
6 years ago |
SELECT rev_page, COUNT(rev_id) AS editcounts
FROM revision
GROUP BY... |
6 years ago |
SELECT rev_page, COUNT(rev_id) AS editcounts
FROM revision
GROUP BY... |
6 years ago |
SELECT COUNT(rev_id) AS editcounts
FROM revision
GROUP BY rev_page
LIMIT 10; |
6 years ago |
SELECT rev_id
FROM revision
LIMIT 10; |
6 years ago |
SELECT rev_id
FROM revision
ORDER BY editcounts DESC
LIMIT 10; |
6 years ago |