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