Last modified: 2014-01-03 15:34:22 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-26. Summary: List of users Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Bryan Tong Minh <bryan@tools.wikimedia.de> ------------------------------------------------------------------------------- From: Betacommand <phoenixoverride@gmail.com> Date: Wed, 04 Jun 2008 00:49:53 ------------------------------------------------------------------------------- en.wiki DragonFly67 would like a list of non-admin users who have created at least 100 articles in mainspace which are not redirects.
------------------------------------------------------------------------------- From: Bryan Tong Minh <bryan@tools.wikimedia.de> Date: Sat, 14 Jun 2008 09:44:16 ------------------------------------------------------------------------------- SELECT rev_user_text, COUNT![][1] AS creations FROM (SELECT rev_user_text, rev_user, MIN(rev_timestamp) FROM revision, page WHERE rev_page = page_id AND page_namespace = 0 AND page_is_redirect = 0 GROUP BY rev_page) AS p LEFT JOIN user_groups ON (ug_user, ug_group) = (rev_user, 'sysop') WHERE ug_group IS NULL GROUP BY rev_user_text HAVING creations > 100 ORDER BY creations; http://toolserver.org/~bryan/stats/dbquery/enwiki_page_creations_non_admins.txt [1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif
------------------------------------------------------------------------------- From: zeyi He <wikipediathinker@googlemail.com> Date: Wed, 13 Aug 2008 14:30:38 ------------------------------------------------------------------------------- hi, i am quite interesting in this list. May i ask does it include all non-users in en-wiki? what's meaning of mainpage? is there all users who create new article or edit article more than 100 times?
------------------------------------------------------------------------------- From: Bryan Tong Minh <bryan@tools.wikimedia.de> Date: Mon, 18 Aug 2008 10:28:26 ------------------------------------------------------------------------------- > May i ask does it include all non-users in en-wiki? See above. It includes all "non-admin users who have created at least 100 articles in mainspace which are not redirects." > what's meaning of mainpage? Mainspace is the article namespace, ns 0. > is there all users who create new article or edit article more than 100 times? I don't understand what you mean.
------------------------------------------------------------------------------- From: zeyi He <wikipediathinker@googlemail.com> Date: Thu, 18 Sep 2008 21:53:14 ------------------------------------------------------------------------------- thanks for answer! the last question is that in "non-admin users who have created at least 100 articles in mainspace which are not redirects", does "create" means started to edit a new article? thanks again. may i ask the date you have run this query for reference?
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: Bryan.TongMinh@Gmail.com CC list: Bryan.TongMinh@Gmail.com, phoenixoverride@gmail.com