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

       Web browser: ---
            Bug ID: 59478
           Summary: DBQ-195 Firsttime contributors to DEWIKI in 2012
           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-195.
Summary: Firsttime contributors to DEWIKI in 2012
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: Thu, 06 Sep 2012 23:57:40
-------------------------------------------------------------------------------

Can somebody please run the following 3 SQL queries and provide me the results? 

    --1
    SELECT user_id, user_name, user_registration FROM user INNER JOIN logging
ON log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT
IN (SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action =
'create';
    --2
    SELECT page_id, page_title, page_namespace, page_is_redirect FROM page;
    --3
    INSERT INTO u_hoo.dbq189 SELECT user_name FROM user INNER JOIN logging ON
log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT IN
(SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action =
'create';
    SELECT rev_id, rev_page, rev_comment, rev_user_text, rev_user,
rev_timestamp FROM revision INNER JOIN u_hoo.dbq189 ON rev_user_text =
dbq189.user_name WHERE rev_deleted = 0 AND rev_user != 0;

These queries are put together by user hoo in this ticket:  
https://jira.toolserver.org/browse/DBQ-189

Thanks for your help

-- 
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