DBQ-110 List of Users of Persian Wikipedia that have at least 1000 unmionr edits in main namespace
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:56 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-110.
Summary: List of Users of Persian Wikipedia that have at least 1000 unmionr edits in main namespace
Issue type: Task - A task that needs to be done.
Priority: Critical
Status: Done
Assignee: DaB. <dab@ts.wikimedia.org>

From: Ladsgroup <ladsgroup@gmail.com>

Date: Sun, 24 Oct 2010 17:25:49

Hello,A election for local committee(similar with ArbCom) is being started
Policy of the election have a condition for candidates that they must have at least 1000 unminor at main namespace
If it's possible please create the list of users.
Thank you

Version: unspecified
Severity: critical

Details

Reference: bz59361

Event Timeline

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

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

• bzimport set Reference to bz59361.

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

From: Autocracy <jeff@storyinmemo.com>

Date: Mon, 27 Dec 2010 12:48:42

http://toolserver.org/~autocracy/dbq-110

select /SLOW_OK/ user_name, count![][1] from user
join revision on rev_user = user_id
where rev_minor_edit = 0
group by user_id
having count![][1] >= 1000
order by count![][1] desc

Some left-to-right / right-to-left funkiness exists depending on the character set of the username.

[1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif

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: wikimedia-bugzilla@dabpunkt.eu
CC list: bugzilla@storyinmemo.com, wikimedia-bugzilla@dabpunkt.eu, ladsgroup@gmail.com

DBQ-110 List of Users of Persian Wikipedia that have at least 1000 unmionr edits in main namespaceClosed, ResolvedPublicActions