Last modified: 2014-01-03 15:47:37 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-71. Summary: More "problematic" users (blocked) - wikipedia.pt Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Lijealso <lijealso@gmail.com> Date: Tue, 18 Aug 2009 06:15:13 ------------------------------------------------------------------------------- I would like to know the top 20 (or so) users with more block applied to them. This is to identify some of the more problematic users on this wiki Thanks User:Lijealso[at]pt.wikipedia
------------------------------------------------------------------------------- From: Fahad Sadah <fahadsadah@gmail.com> Date: Sat, 26 Sep 2009 08:14:18 ------------------------------------------------------------------------------- http:/toolserver.org/~fahad/dbq/71 Used SELECT `log_title` , COUNT( * ) AS count FROM `logging` WHERE `log_action` = 'block' GROUP BY `log_title` HAVING count >1 ORDER BY count DESC LIMIT 21 21, not 20, because ' ' (space) has been blocked 57 times.
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: fahadsadah@gmail.com, lijealso.wikimedia@gmail.com