Last modified: 2014-01-03 15:37:52 UTC
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!
------------------------------------------------------------------------------- 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