Last modified: 2014-01-03 15:57:56 UTC
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> Date: Thu, 30 Dec 2010 18:47:58 ------------------------------------------------------------------------------- I would like have a list of members of fawikinews with most edits on articles except bot users, thank you in advance
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 31 Dec 2010 09:59:17 ------------------------------------------------------------------------------- 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