Re: [Wiki-research-l] Query user history edits

2019-03-28 Thread Nick Wilson (Quiddity)
count creation is currently disabled. We apologise for the > inconvenience." > > > Best, > > Haifeng Zhang > > From: Wiki-research-l on > behalf of Maximilian Klein > Sent: Wednesday, March 27, 2019 12:46:39 PM > To: Research into Wik

Re: [Wiki-research-l] Query user history edits

2019-03-27 Thread Haifeng Zhang
, March 27, 2019 12:46:39 PM To: Research into Wikimedia content and communities Subject: Re: [Wiki-research-l] Query user history edits Sample query I just wrote that get the edit count of a single user (by username) during a period of time on Quarry: https://quarry.wmflabs.org/query/34716 . The g

Re: [Wiki-research-l] Query user history edits

2019-03-27 Thread Maximilian Klein
Sample query I just wrote that get the edit count of a single user (by username) during a period of time on Quarry: https://quarry.wmflabs.org/query/34716 . The gotcha that might be important for this query is using the table `revision_userindex` rather than the play revision table which doesn't

Re: [Wiki-research-l] Query user history edits

2019-03-27 Thread Aaron Halfaker
If you share why kind of query you'd like to run, people on this list might even write you an example Quarry :) See also: https://www.mediawiki.org/wiki/Talk:Quarry People post query requests that and others help them draft the right query for their needs. On Wed, Mar 27, 2019 at 11:28 AM James

Re: [Wiki-research-l] Query user history edits

2019-03-27 Thread Morten Wang
Hi Haifeng, In my experience, this depends on how many users you're looking to get information about. Is it a few hundred? A few thousand? A million+? If you are getting the edit history for a limited number of users (say a few hundred to a few thousand), then using the API can work well. One