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.orgwrote:
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
