Commons talk:Database reports/Noticeboard stats
Jump to navigation
Jump to search
sql used |
---|
SELECT rev_user_text AS user, COUNT(rev_user_text) AS ucount
FROM revision
WHERE rev_page = "PAGEID"
GROUP BY rev_user_text
ORDER BY ucount DESC
LIMIT 65;
|