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.
Assignee: Hoo man <firstname.lastname@example.org>
From: Chris55 <email@example.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! 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.