From: Hoo man <hoo@online.de>

Date: Fri, 06 Jul 2012 14:38:36

Detecting if a user was new at a given time isn't trivial, so I left that out for now. Please notice, that IPs are counted as users as well.
SQL:

SELECT /* SLOW_OK */ COUNT(*) AS edit_count, COUNT(DISTINCT rev_user_text) AS user_count, LEFT(rev_timestamp, 6) AS month FROM page INNER JOIN revision ON rev_page = page_id WHERE page_namespace = 4 AND page_title LIKE 'Pagine_da_cancellare/%' AND LEFT(rev_timestamp, 6) > 201000 GROUP BY LEFT(rev_timestamp, 6);

Result:
http://toolserver.org/~hoo/dbq/dbq-190.txt (plain text)

From: Nickanc <nickanc.wiki@gmail.com>

Date: Sun, 08 Jul 2012 17:03:32

Ok, no problem for newbies. Maybe, is it possible to distinguish between registered users and IP? I mean, can we count both how many IPs edited per month and how many registered users edited per month?

From: Federico Leva <federicoleva@tiscali.it>

Date: Mon, 16 Jul 2012 13:57:36

We also need the average number of participants for request (with median and standard deviation).

For the "newbies" part, ideally it would be interesting to count how many of those participants
a) are sysops,
b) have 1-50, 51-500, 501-5000, or 5001+ edits
in each month.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: federicoleva@tiscali.it, hoo@online.de, nickanc.wiki@gmail.com