Last modified: 2014-01-03 16:06:27 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-160. Summary: user contributions in spicfice period Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Tue, 27 Sep 2011 10:22:09 ------------------------------------------------------------------------------- Hi, I want a query that tell me that specific user i.e.(reza1615) how many contributions did have from first-till specific time? 1- for all of name spaces 2-fa.wiki 3- user name and end time are variable in advance thank you for your time
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Tue, 27 Sep 2011 21:36:48 ------------------------------------------------------------------------------- Well, the topic of this project is more about running queries on WMF databases than on writing SQL queries, but here we go: SELECT COUNT(*) FROM revision WHERE rev_user_text = 'User name' AND rev_timestamp < TimestampOfTheTimeWeCountQueriesUpTo; Please notice that Mediawiki uses it's own timestamp format.
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: hoo@online.de CC list: reza.energy@gmail.com, hoo@online.de