Last modified: 2014-01-03 15:47:31 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-70. Summary: Number of editors with more than 250 edits on the main namespace on pt.wikipedia Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Ben Kurtovic (earwig) <ben.kurtovic@verizon.net> ------------------------------------------------------------------------------- From: Lijealso <lijealso@gmail.com> Date: Tue, 18 Aug 2009 06:04:58 ------------------------------------------------------------------------------- I Would like to know how many editors have more than 250 edits on the main namespace on pt.wikipedia This is related with a proposed change in the vote right on pt.wiki (100 edits to 250 edits) Thanks User:Lijealso[at]pt.wikipedia PS.: If possible, also ussers with more than 100 edits main NS (to compare)
------------------------------------------------------------------------------- From: Ben Kurtovic (earwig) <ben.kurtovic@verizon.net> Date: Tue, 18 Aug 2009 18:36:19 ------------------------------------------------------------------------------- Done: The 250 edits query result can be found at http://toolserver.org/~earwig/reports/ptwiki-250edits.txt The 100 edits query result can be found at http://toolserver.org/~earwig/reports/ptwiki-100edits.txt
------------------------------------------------------------------------------- From: Ben Kurtovic (earwig) <ben.kurtovic@verizon.net> Date: Tue, 18 Aug 2009 18:37:14 ------------------------------------------------------------------------------- The SQL queries used were: SELECT user_name FROM user WHERE user_editcount > 250; and SELECT user_name FROM user WHERE user_editcount > 100; Thanks! – The Earwig – http://en.wikipedia.org/wiki/User:The_Earwig
------------------------------------------------------------------------------- From: Lijealso <lijealso@gmail.com> Date: Tue, 18 Aug 2009 18:47:14 ------------------------------------------------------------------------------- Thanks The query was on main namespace [not talk pages], right? Lijealso
------------------------------------------------------------------------------- From: Ben Kurtovic (earwig) <ben.kurtovic@verizon.net> Date: Tue, 18 Aug 2009 18:53:17 ------------------------------------------------------------------------------- Uh oh, it looks like I misread your description. No, it has been done on all namespaces. That makes the query a bit more difficult, please give me some time to fix it. Sorry for causing you trouble.
------------------------------------------------------------------------------- From: Lijealso <lijealso@gmail.com> Date: Tue, 18 Aug 2009 19:41:20 ------------------------------------------------------------------------------- No trouble ![][1] Thank you for taking your time Lijealso [1]: https://jira.toolserver.org/images/icons/emoticons/smile.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: (none) CC list: lijealso.wikimedia@gmail.com