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>
I Would like to have a list members of editor user group who have most reviewes on the main namespace on fa.wikinews, Thanks
Version: unspecified
Severity: major
From: Hoo man <hoo@online.de>
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>
how i can filter output where log action is not "approve-a"?
From: Hoo man <hoo@online.de>
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