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