DBQ-71 More "problematic" users (blocked) - wikipedia.pt
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-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

Version: unspecified
Severity: major

Details

Reference: bz59326

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 bz59326.

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

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

DBQ-71 More "problematic" users (blocked) - wikipedia.ptClosed, ResolvedPublicActions