aboutsummaryrefslogtreecommitdiffstats
path: root/admin/stats.php
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--admin/stats.php7
1 files changed, 5 insertions, 2 deletions
diff --git a/admin/stats.php b/admin/stats.php
index b693ebcaa..1ce07649a 100644
--- a/admin/stats.php
+++ b/admin/stats.php
@@ -116,14 +116,17 @@ check_status(ACCESS_ADMINISTRATOR);
$query = '
SELECT
date,
- HOUR(time) AS hour,
+ hour(time) AS hour,
MAX(id) AS max_id,
COUNT(*) AS nb_pages
FROM '.HISTORY_TABLE.'
WHERE summarized = \'false\'
GROUP BY
+ date,
+ hour
+ ORDER BY
date ASC,
- HOUR(time) ASC
+ hour ASC
;';
$result = pwg_query($query);