https://bugzilla.wikimedia.org/show_bug.cgi?id=59472

       Web browser: ---
            Bug ID: 59472
           Summary: DBQ-189 firsttime contributors to DEWIKI in June
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from https://jira.toolserver.org/browse/DBQ-189.
Summary: firsttime contributors to DEWIKI in June 
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>

-------------------------------------------------------------------------------
From: Gregor Martynus <gre...@martynus.net>
Date: Mon, 02 Jul 2012 19:03:53
-------------------------------------------------------------------------------

I'd need 3 things for a study of a friend of mine:

1. users that manually signed up in 2012 and have not been blocked.  
2. All pages  
3. revisions by the users from 1.

As a Sidenode, could I have a SQL dump of a small wikipedia like
simple.wikipedia.org so I can build and test the queries myself, so you don't
have to? Tables: user (without sensitive columns of course), ipblocks, logging,
revision, page.

Could anybody run these queries against DE wiki and send me the results? I
think the SQL queries should look like this:

    -- Users that manually signed up in 2012, flagged if they have been blockd

    SELECT
      user_id,
      user_name,
      log_timestamp AS signed_up_at
      ipb_timestamp AS blocked_at
    FROM
      user
    LEFT JOIN logging  ON user_id = log_user
    LEFT JOIN ipblocks ON user_id = ipb_user
    WHERE type = 'new_users' 
      AND action = 'create'
      AND log_timestamp > "2012";

    -- all pages
    SELECT
      page_id,
      page_name,
      page_namespace,
      page_is_redirect,
    FROM
      page;

    -- revisions from 2012
    SELECT
      rev_id,
      rev_page,
      rev_comment,
      rev_deleted,
      rev_user,
      rev_timestamp
    FROM
      revision
    WHERE
      rev_timestamp > "2012";




    -- THANKS A LOT

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to