aboutsummaryrefslogtreecommitdiff
path: root/backend/handlers/stats.go
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--backend/handlers/stats.go4
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/handlers/stats.go b/backend/handlers/stats.go
index 06748c3..04618cc 100644
--- a/backend/handlers/stats.go
+++ b/backend/handlers/stats.go
@@ -109,7 +109,7 @@ func Timeline(c *gin.Context) {
109 WITH date_series AS ( 109 WITH date_series AS (
110 SELECT DISTINCT record_date as date 110 SELECT DISTINCT record_date as date
111 FROM map_history 111 FROM map_history
112 WHERE category_id = 1 AND map_id <= 60 AND record_date >= '2013-01-31' 112 WHERE category_id = 1 AND map_id <= 60 AND record_date >= '2013-01-01'
113 ORDER BY record_date 113 ORDER BY record_date
114 ), 114 ),
115 map_best_at_date AS ( 115 map_best_at_date AS (
@@ -136,7 +136,7 @@ func Timeline(c *gin.Context) {
136 WITH date_series AS ( 136 WITH date_series AS (
137 SELECT DISTINCT record_date as date 137 SELECT DISTINCT record_date as date
138 FROM map_history 138 FROM map_history
139 WHERE category_id = 1 AND map_id > 60 AND record_date >= '2013-01-31' 139 WHERE category_id = 1 AND map_id > 60 AND record_date >= '2013-01-01'
140 ORDER BY record_date 140 ORDER BY record_date
141 ), 141 ),
142 map_best_at_date AS ( 142 map_best_at_date AS (