https://bugzilla.wikimedia.org/show_bug.cgi?id=59363

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@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)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to