Last modified: 2014-01-03 15:56:44 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-112. Summary: List members of editor user group who have most reviewes on articles Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Mjbmr <mjbmri@gmail.com> Date: Thu, 23 Dec 2010 13:02:42 ------------------------------------------------------------------------------- I Would like to have a list members of editor user group who have most reviewes on the main namespace on fa.wikinews, Thanks
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sun, 26 Dec 2010 23:44:30 ------------------------------------------------------------------------------- http://toolserver.org/~hoo/dbq/fawikinews_editors_2010-12-27.txt SQL: SELECT user.user_name as user, COUNT(logging.log_user) as reviews FROM logging INNER JOIN user ON logging.log_user = user.user_id INNER JOIN user_groups ON user_groups.ug_user = user.user_id WHERE user_groups.ug_group = "editor" AND logging.log_type = "review" GROUP BY user ORDER BY reviews DESC;
------------------------------------------------------------------------------- From: Mjbmr <mjbmri@gmail.com> Date: Mon, 27 Dec 2010 14:36:25 ------------------------------------------------------------------------------- Thank you so much
------------------------------------------------------------------------------- From: Mjbmr <mjbmri@gmail.com> Date: Thu, 06 Jan 2011 16:32:23 ------------------------------------------------------------------------------- how i can filter output where log action is not "approve-a"?
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Thu, 06 Jan 2011 17:51:48 ------------------------------------------------------------------------------- You can't, but I can, with a slightly modified query: SELECT user.user_name as user, COUNT(logging.log_user) as reviews FROM logging INNER JOIN user ON logging.log_user = user.user_id INNER JOIN user_groups ON user_groups.ug_user = user.user_id WHERE user_groups.ug_group = "editor" AND logging.log_type = "review" AND logging.log_action != "approve-a" GROUP BY user ORDER BY reviews DESC; Result: http://toolserver.org/~hoo/dbq/dbq-112_2.txt (new results) http://toolserver.org/~hoo/dbq/dbq-112.txt (old results)
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: hoo@online.de CC list: hoo@online.de, mjbmri@gmail.com