aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models
diff options
context:
space:
mode:
Diffstat (limited to 'server/models')
-rw-r--r--server/models/video/video-channel.ts2
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/video/video-channel.ts b/server/models/video/video-channel.ts
index 5e6541837..78fc3d7e4 100644
--- a/server/models/video/video-channel.ts
+++ b/server/models/video/video-channel.ts
@@ -191,7 +191,7 @@ export type SummaryOptions = {
191 'SELECT days.day AS day, ' + 191 'SELECT days.day AS day, ' +
192 'COALESCE(SUM(views.views), 0) AS views ' + 192 'COALESCE(SUM(views.views), 0) AS views ' +
193 'FROM days ' + 193 'FROM days ' +
194 `LEFT JOIN views ON date_trunc('day', "views"."createdAt") = days.day ` + 194 `LEFT JOIN views ON date_trunc('day', "views"."startDate") = date_trunc('day', days.day) ` +
195 'GROUP BY 1 ' + 195 'GROUP BY 1 ' +
196 'ORDER BY day ' + 196 'ORDER BY day ' +
197 ') t' + 197 ') t' +