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

       Web browser: ---
            Bug ID: 59384
           Summary: DBQ-129 create a list of total individual user edits
                    per month for English wikipedia
           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-129.
Summary: create a list of total individual user edits per month for English
wikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>

-------------------------------------------------------------------------------
From: Chris55 <mosch...@googlemail.com>
Date: Mon, 21 Mar 2011 23:38:58
-------------------------------------------------------------------------------

Output 3 colums: userid, month, totaledits_this_month for English wikipedia
from the start with users with non-zero edits. IP edits can be disregarded.  
Having now looked at the database definition I believe that the sql statement I
need executed is:  
select rev_user, left(rev_timestamp,6), count![][1] from revision where
rev_user!=0 group by rev_user,left(rev_timestamp,6);

If doing this in parts an extra condition such as left(rev_timestamp,4)=='2005'
is needed.  
Thanks

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

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