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 <hoo@online.de>
From: Chris55 <moschris@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
Version: unspecified
Severity: major