DBQ-165 Number of creation in a day
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:07 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-165.
Summary: Number of creation in a day
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Liangent <liangent@gmail.com>

From: Mjbmr <mjbmri@gmail.com>

Date: Sat, 29 Oct 2011 03:24:25

Hello, I'd like to have number of creations in main namespace in last 24 hours in fawiki, thanks.

Version: unspecified
Severity: major

Details

Reference: bz59433

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 bz59433.

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

From: Liangent <liangent@gmail.com>

Date: Sat, 29 Oct 2011 04:26:15

mysql> select count(*) from recentchanges where rc_type=1 and rc_namespace=0 and rc_timestamp > 20111028032400 and rc_timestamp <= 20111029032400;

+----------+
| count(*) |
+----------+
|      459 |
+----------+
1 row in set (0.16 sec)

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: liangent@gmail.com
CC list: liangent@gmail.com, mjbmri@gmail.com

DBQ-165 Number of creation in a dayClosed, ResolvedPublicActions