DBQ-160 user contributions in spicfice period
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:06 PM

Description

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

Version: unspecified
Severity: major

Details

Reference: bz59426

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:30 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59426.

JiraBugConverter created this task.Jan 3 2014, 4:06 PM

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

DBQ-160 user contributions in spicfice periodClosed, ResolvedPublicActions