Last modified: 2014-01-03 16:07:05 UTC
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.
------------------------------------------------------------------------------- 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