DBQ-69 List of most active users to patrol on ptwikipedia
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:47 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-69.
Summary: List of most active users to patrol on ptwikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Betacommand <phoenixoverride@gmail.com>

From: Lijealso <lijealso@gmail.com>

Date: Tue, 18 Aug 2009 05:53:24

I would like a query like this one:

https://jira.toolserver.org/browse/DBQ-53

Concerning the last month.

Thanks

User:Lijealso[at]pt.wikipedia

Version: unspecified
Severity: major

Details

Reference: bz59324

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:23 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59324.

JiraBugConverter created this task.Jan 3 2014, 3:47 PM

From: Fahad Sadah <fahadsadah@gmail.com>

Date: Sat, 26 Sep 2009 07:24:06

I'm running it for August.

Query is 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 > 1249081200 AND log_timestamp < 1251759600 AND log_params LIKE '%0' GROUP BY u.user_name ORDER BY antall DESC;

From: Fahad Sadah <fahadsadah@gmail.com>

Date: Sat, 26 Sep 2009 07:33:44

No results.

From: Betacommand <phoenixoverride@gmail.com>

Date: Sat, 26 Dec 2009 04:03:03

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 > '20091125000000' AND log_params LIKE '%0' GROUP BY u.user_name ORDER BY antall DESC;

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: phoenixoverride@gmail.com
CC list: phoenixoverride@gmail.com, fahadsadah@gmail.com, lijealso.wikimedia@gmail.com

DBQ-69 List of most active users to patrol on ptwikipediaClosed, ResolvedPublicActions