So: attached, data - everyone with >5 actions in the recentchanges table. Now, the result-set is only ~7,000 entries long, which I'm preeetty sure is unreliable somehow, but I've applied a decade and a half of collected comp sci studies and around 3 decades of practical experience to the problem and they've all gone 'er. no idea. It should work'. If anyone else can spot what's going wrong, most appreciated :).

On 30 January 2013 05:11, Oliver Keyes <okeyes@wikimedia.org> wrote:
Sure; that's fairly trivial (thank the lord for the recentchanges table). I'll get on it when it's not 5am.


On 30 January 2013 04:54, Matthew Flaschen <mflaschen@wikimedia.org> wrote:
On 01/29/2013 11:47 PM, Matthew Flaschen wrote:
> That is useful (active, but either reader or editor), but I would
> appreciate if you could do the same for people who have made 5 or more
> mainspace edits in the same time period.

I see now that your query is 5+ lifetime edits in any namespace (based
on user_editcount).

If you can do people who made 5+ mainspace edits during that period,
that would be great.  If not, some other measure of active editing would
be good.

Sorry I wasn't clear originally.

Matt Flaschen

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics



--
Oliver Keyes
Community Liaison, Product Development
Wikimedia Foundation



--
Oliver Keyes
Community Liaison, Product Development
Wikimedia Foundation