From: Autocracy <jeff@storyinmemo.com>

Date: Thu, 11 Sep 2008 14:15:05

Yes it is _possible_, but it's also a REALLY long query. In fact, it is so disgustingly long that I previously suggested it be handled by means of a separate table where that information is inserted by a trigger.

The short answer is: I don't think you can get this information.

From: zeyi He <wikipediathinker@googlemail.com>

Date: Thu, 18 Sep 2008 21:48:33

hi, i found the qury here, https://jira.toolserver.org/browse/DBQ-3. so may i ask is it possible to run some like this with the number of edit as well?
thanks.

From: Bryan Tong Minh <bryan@tools.wikimedia.de>

Date: Fri, 26 Sep 2008 09:31:27

Should be something like:

SELECT lr_user, COUNT(lr_title) AS lr_creation_count, lr_editcount AS user_editcount FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user FROM page, revision WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page = page_id GROUP BY rev_page) AS lowest_revision, user WHERE lr_user = user_name GROUP BY lr_user HAVING lr_creation_count > 5 ORDER BY lr_creation_count DESC;

For which wiki would you like it?

From: zeyi He <wikipediathinker@googlemail.com>

Date: Sun, 28 Sep 2008 15:59:47

English Wiki? thanks very much!
Is that possible you give me a date and time when you finish this query? I need them for reference, thanks.

From: MZMcBride <mzmcbride@gmail.com>

Date: Fri, 20 Mar 2009 18:19:19

Running query now in screen.

SELECT

lr_user,
COUNT(lr_title) AS lr_creation_count,
user_editcount AS lr_editcount
FROM (SELECT
page_title AS lr_title,
MIN(rev_id) AS lr_rev_id,
rev_user_text AS lr_user
FROM page, revision
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_page = page_id
GROUP BY rev_page) AS lowest_revision
JOIN user ON lr_user = user_name
GROUP BY lr_user
HAVING lr_creation_count > 0
ORDER BY lr_creation_count DESC;

From: MZMcBride <mzmcbride@gmail.com>

Date: Sat, 21 Mar 2009 05:34:45

Query finished. Available at http://toolserver.org/~mzmcbride/dbq/dbq-39.txt.gz

Data as of Saturday, March 21, 2009 4:48 (UTC).

Please open a new issue for further queries.

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: b@mzmcbride.com, Bryan.TongMinh@Gmail.com, bugzilla@storyinmemo.com