diff options
Diffstat (limited to 'server/models/video/sql/videos-id-list-query-builder.ts')
-rw-r--r-- | server/models/video/sql/videos-id-list-query-builder.ts | 5 |
1 files changed, 3 insertions, 2 deletions
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 879f23406..76aafb883 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,10 @@ export class VideosIdListQueryBuilder extends AbstractRunQuery { | |||
367 | ' WHERE "videoShare"."videoId" = "video"."id"' + | 367 | ' WHERE "videoShare"."videoId" = "video"."id"' + |
368 | ' )' + | 368 | ' )' + |
369 | ' OR' + | 369 | ' OR' + |
370 | ' EXISTS (' + // Videos published by channels we follow | 370 | ' EXISTS (' + // Videos published by channels or accounts we follow |
371 | ' SELECT 1 from "actorFollow" ' + | 371 | ' SELECT 1 from "actorFollow" ' + |
372 | ' WHERE "actorFollow"."targetActorId" = "videoChannel"."actorId" AND "actorFollow"."actorId" = :followerActorId ' + | 372 | ' WHERE ("actorFollow"."targetActorId" = "account"."actorId" OR "actorFollow"."targetActorId" = "videoChannel"."actorId") ' + |
373 | ' AND "actorFollow"."actorId" = :followerActorId ' + | ||
373 | ' AND "actorFollow"."state" = \'accepted\'' + | 374 | ' AND "actorFollow"."state" = \'accepted\'' + |
374 | ' )' | 375 | ' )' |
375 | 376 | ||