From 562724a1ed13fe93aba08ca1a0f8e029819e9f32 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 3 Jan 2020 11:53:51 +0100 Subject: Fix totalRepliesFromVideoAuthor SQL request --- server/models/video/video-comment.ts | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'server/models/video') diff --git a/server/models/video/video-comment.ts b/server/models/video/video-comment.ts index c2798e82a..fb4d16b4d 100644 --- a/server/models/video/video-comment.ts +++ b/server/models/video/video-comment.ts @@ -62,8 +62,10 @@ enum ScopeNames { '(' + 'SELECT COUNT("replies"."id") ' + 'FROM "videoComment" AS "replies" ' + + 'INNER JOIN "video" ON "video"."id" = "replies"."videoId" ' + + 'INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" ' + 'WHERE "replies"."originCommentId" = "VideoCommentModel"."id" ' + - 'AND "accountId" = ' + userAccountId + + 'AND "replies"."accountId" = "videoChannel"."accountId"' + ')' ), 'totalRepliesFromVideoAuthor' -- cgit v1.2.3