https://bugzilla.wikimedia.org/show_bug.cgi?id=59308
Web browser: ---
Bug ID: 59308
Summary: DBQ-53 List of most active users to patrol on nowiki
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
This issue was converted from https://jira.toolserver.org/browse/DBQ-53.
Summary: List of most active users to patrol on nowiki
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)
-------------------------------------------------------------------------------
From: Lars Age Kamfjord <lars-toolserverw...@kamfjord.org>
Date: Thu, 20 Nov 2008 11:34:40
-------------------------------------------------------------------------------
We've had a lot of users doing a big job in patrolling the last week, and I'd
like to know how much they've worked with this so they can get some barnstars
for it.
Could you please run the following query:
SELECT u.user_name, COUNT(l.log_id) AS antall FROM logging l LEFT JOIN user u
ON (l.log_user = u.user_id) WHERE log_type = 'patrol' AND log_timestamp >
20081115000000 AND log_params LIKE '%0' GROUP BY u.user_name ORDER BY antall
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
