Page MenuHomePhabricator

DBQ-70 Number of editors with more than 250 edits on the main namespace on pt.wikipedia
Closed, ResolvedPublic

Description

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)


Version: unspecified
Severity: major

Details

Reference
bz59325

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:23 AM
bzimport set Reference to bz59325.

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