diff options
Diffstat (limited to 'server/models/video/video-channel.ts')
-rw-r--r-- | server/models/video/video-channel.ts | 2 |
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' + |