From: MZMcBride <mzmcbride@gmail.com>

Date: Fri, 20 Mar 2009 18:05:26

Which wikis specifically do you want this query run on?

From: Dutchresearch <mail@basvaneijk.nl>

Date: Fri, 20 Mar 2009 19:40:59

Just wikipedia as 'encyclopedia' not books etc. I figured out the db somewhat on revisions and pages, and also found a query here https://jira.toolserver.org/browse/DBQ-3

but i can't figure out how to get
member name | total started articles per user | total edits on articles per user | registration date | Last active date

with the 2 tabels from the [page,revision] dumps i dl.

as it comes for languages the more the better, but i'd be happy with dutch, german and swedish..

also if i had known how to write the sql less expensive then i could run it myself.

From: MZMcBride <mzmcbride@gmail.com>

Date: Fri, 20 Mar 2009 20:13:40

So you want svwiki_p (sv.wikipedia.org), dewiki_p (de.wikipedia.org), and nlwiki_p (nl.wikipedia.org)? Is this correct?

From: Dutchresearch <mail@basvaneijk.nl>

Date: Sat, 21 Mar 2009 07:37:35

yes that's correct

From: Dutchresearch <mail@basvaneijk.nl>

Date: Tue, 31 Mar 2009 11:26:06

Could anyone help with this, there is no one assigned...

From: Legoktm <legoktm@pacbell.net>

Date: Wed, 01 Apr 2009 23:24:27

I have started running the queries.

From: Dutchresearch <mail@basvaneijk.nl>

Date: Tue, 07 Apr 2009 06:44:15

Curious... How are they going?

From: Legoktm <legoktm@pacbell.net>

Date: Thu, 09 Apr 2009 06:11:39

See http://toolserver.org/~legoktm/DBQ/58/
Query used was:
mysql -hsql-s2 nlwiki_p -e "SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT lr_user, COUNT(lr_title) AS lr_creation_count, lr_edit_count, lr_registration FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user, user_editcount AS lr_edit_count, user_registration AS lr_registration FROM page, revision, user WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page = page_id AND user_name = rev_user_text GROUP BY rev_page) AS lowest_revision GROUP BY lr_user HAVING lr_creation_count > 5 ORDER BY lr_creation_count DESC; /*SLOW OK*/" > nlwiki_p.txt

From: Dutchresearch <mail@basvaneijk.nl>

Date: Thu, 09 Apr 2009 11:54:26

wow i'm really happy ![][1]

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

From: Dutchresearch <mail@basvaneijk.nl>

Date: Thu, 09 Apr 2009 12:21:30

sry, but why are some registration dates null?

conversion, before given date or after?

thnx Bas

From: Lars Age Kamfjord <lars-toolserverwiki@kamfjord.org>

Date: Sun, 02 Aug 2009 14:21:18

Registration date is not registrered for users created before 2005-12-22

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: legoktm.wikipedia@gmail.com
CC list: b@mzmcbride.com, legoktm.wikipedia@gmail.com