Last modified: 2014-01-03 15:45:46 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-58. Summary: user contributions article started countries NL-GE-SW Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Legoktm <legoktm@pacbell.net> ------------------------------------------------------------------------------- From: Dutchresearch <mail@basvaneijk.nl> Date: Wed, 04 Mar 2009 00:29:42 ------------------------------------------------------------------------------- Hi i am new to the TS and i would like to have similar info as in post https://jira.toolserver.org/browse/DBQ-3 Could anyone help me get results for 1. dutch db: member name | total started articles | total edits on articles | registration date | Last active date 2. german db: member name | total started articles | total edits on articles | registration date | Last active date 3. swedish db: member name | total started articles | total edits on articles | registration date | Last active date I will use it for my thesis on UGC which i will publish CC kind regards, Bas
------------------------------------------------------------------------------- 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