DBQ-43 list of admin in english wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:37 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-43.
Summary: list of admin in english wiki
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: SQL <sxwiki@gmail.com>

From: zeyi He <wikipediathinker@googlemail.com>

Date: Sun, 28 Sep 2008 16:58:52

Can I have two tables of admin in english wikipedia, first includes columns with admin name, the starting edit date, the starting admin date, the ending admin date (if possible), the number of edit, the number of edit in every different namespace, like article, templete, article talk.

The second one with their admin actions, like user blocked-Action. page deleted-Action, page moved-Action, page patrolled, page protected-Action, pages restored, user unblocked, page unblocked, file uploaded.

Thanks!

Version: unspecified
Severity: major

Details

Reference: bz59298

Event Timeline

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

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

• bzimport set Reference to bz59298.

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

From: SQL <sxwiki@gmail.com>

Date: Tue, 30 Sep 2008 14:12:47

I am running your queries now.

The second is done, and you can find it at http://toolserver.org/~sql/DBQ/DBQ-43B.txt (SQL is at http://toolserver.org/~sql/DBQ/DBQ-43B.sql )

I'll post here when the first is done

From: SQL <sxwiki@gmail.com>

Date: Tue, 30 Sep 2008 14:58:00

First one is done now too, result is at http://toolserver.org/~sql/DBQ/DBQ-43A.txt

Query source (Huge! ![][1]) is at http://toolserver.org/~sql/DBQ/DBQ-43A.sql

[1]: https://jira.toolserver.org/images/icons/emoticons/tongue.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: sxwiki@gmail.com
CC list: sxwiki@gmail.com

DBQ-43 list of admin in english wikiClosed, ResolvedPublicActions