This issue was converted from https://jira.toolserver.org/browse/DBQ-117.
Summary: List of non-bot users with most edits in main namespace
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)
From: Mjbmr <mjbmri@gmail.com>
I would like have a list of members of fawikinews with most edits on articles except bot users, thank you in advance
Version: unspecified
Severity: major
From: Hoo man <hoo@online.de>
SQL:
SELECT rev_user_text AS user_name, COUNT(*) AS edits FROM revision INNER JOIN page ON revision.rev_page = page.page_id LEFT JOIN (SELECT ug_group as is_bot, ug_user FROM user_groups WHERE ug_group = 'bot') as groups ON revision.rev_user = groups.ug_user WHERE isnull(is_bot) AND page.page_namespace = 0 GROUP BY revision.rev_user_text ORDER BY edits DESC;
Results:
http://toolserver.org/~hoo/dbq/dbq-117.txt (plain text)
http://toolserver.org/~hoo/dbq/dbq-117_wiki.txt (wiki table)
This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.
If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: hoo@online.de, mjbmri@gmail.com