aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models/video
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2021-12-17 15:21:24 +0100
committerChocobozzz <me@florianbigard.com>2021-12-17 15:21:24 +0100
commit84845992947365412733d056b9a9fe6ff15bd53f (patch)
tree0926f6d65a46ee6b365664d787102606d942115a /server/models/video
parent709565486f86ce9ee553e2e45372ce8226a782fb (diff)
downloadPeerTube-84845992947365412733d056b9a9fe6ff15bd53f.tar.gz
PeerTube-84845992947365412733d056b9a9fe6ff15bd53f.tar.zst
PeerTube-84845992947365412733d056b9a9fe6ff15bd53f.zip
Fix subscriptions
Diffstat (limited to 'server/models/video')
-rw-r--r--server/models/video/sql/videos-id-list-query-builder.ts5
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