From: SQL <sxwiki@gmail.com>

Date: Wed, 13 Aug 2008 23:13:11

Done, please see http://toolserver.org/~sql/DBQ/36.txt.gz for the results.

I did it as close as I could to what you specified, and, unfortunately, I will not be able to re-run this query at a later date, as it took about five hours to run.

Hope this helps!

Here's the query incase anyone can do it better:

SELECT CONCAT('* [[User:',user_name,']]'),
 (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id WHERE rev_user = user_id AND page_namespace = 1) as talk_edits,
 (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id WHERE rev_user = user_id AND page_namespace = 3) as utalk_edits
 FROM user
 WHERE user_editcount > 0
 AND user_id IN (SELECT rev_user FROM revision JOIN page ON rev_page = page_id WHERE page_namespace = 1 OR page_namespace = 3)
 AND user_id NOT IN (SELECT rev_user FROM revision JOIN page ON rev_page = page_id WHERE page_namespace != 1 AND page_namespace != 3);

From: zeyi He <wikipediathinker@googlemail.com>

Date: Mon, 25 Aug 2008 14:56:45

thanks for your help! but , i can't open the file you provided? is it a valid website?

From: SQL <sxwiki@gmail.com>

Date: Mon, 25 Aug 2008 18:13:39

Very sorry about that! ![][1] I mistyped the file name when I was saving it. That link will work now.

[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

From: zeyi He <wikipediathinker@googlemail.com>

Date: Tue, 26 Aug 2008 14:22:04

HI, SQL,

Thanks a lot. yes, the link works now.

May i make sure this text is three columns, "user name" "the number of edit in article discuss page" "the number of edit in user discuss page"?

or maybe i am wrong?

and for research use, may i ask the time of collecting this data for reference?

thanks again.

From: zeyi He <wikipediathinker@googlemail.com>

Date: Tue, 02 Sep 2008 11:14:25

Hi, thanks.

i still need your clarifying about data, because i see some thing unusual on text. would you mind to tell me what is that mean?

i found some 0*, what does it mean? thanks!

From: Misza <misza1313@gmail.com>

Date: Sun, 28 Sep 2008 16:49:34

The file uses Unix newline characters. If you open it in braindead editors like notepad.exe, you will see the 0 (user talk edits) from the previous line concatenated with the * (wiki bullet point) from the next line. Open the file in a more sophisticated editor.

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: misza@misza.net, sxwiki@gmail.com