Last modified: 2014-01-03 15:47:18 UTC
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
------------------------------------------------------------------------------- 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
