From 9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 17 Dec 2021 14:42:31 +0100 Subject: Fix internal user subscription --- server/models/video/sql/videos-id-list-query-builder.ts | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'server/models') diff --git a/server/models/video/sql/videos-id-list-query-builder.ts b/server/models/video/sql/videos-id-list-query-builder.ts index d825225ab..879f23406 100644 --- a/server/models/video/sql/videos-id-list-query-builder.ts +++ b/server/models/video/sql/videos-id-list-query-builder.ts @@ -367,9 +367,9 @@ export class VideosIdListQueryBuilder extends AbstractRunQuery { ' WHERE "videoShare"."videoId" = "video"."id"' + ' )' + ' OR' + - ' EXISTS (' + // Videos published by accounts we follow + ' EXISTS (' + // Videos published by channels we follow ' SELECT 1 from "actorFollow" ' + - ' WHERE "actorFollow"."targetActorId" = "account"."actorId" AND "actorFollow"."actorId" = :followerActorId ' + + ' WHERE "actorFollow"."targetActorId" = "videoChannel"."actorId" AND "actorFollow"."actorId" = :followerActorId ' + ' AND "actorFollow"."state" = \'accepted\'' + ' )' -- cgit v1.2.3