Page MenuHomePhabricator

DBQ-53 List of most active users to patrol on nowiki
Closed, ResolvedPublic

Description

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-toolserverwiki@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;


Version: unspecified
Severity: major

Details

Reference
bz59308

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:22 AM
bzimport set Reference to bz59308.

From: Lars Age Kamfjord <lars-toolserverwiki@kamfjord.org>

Date: Thu, 20 Nov 2008 11:41:16

changed the query to include log_params LIKE '%0' as I'm not interested in autopatrolled


From: MZMcBride <mzmcbride@gmail.com>

Date: Thu, 20 Nov 2008 17:13:10

Ran query as written. Results available here: http://toolserver.org/~mzmcbride/dbq/dbq-53.txt

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: (none)
CC list: b@mzmcbride.com