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

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

-- 
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