aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models/video/sql
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2021-12-17 14:42:31 +0100
committerChocobozzz <me@florianbigard.com>2021-12-17 14:42:31 +0100
commit9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a (patch)
treeff118bf9f733d19b28abd6ff35fb76fa236c0101 /server/models/video/sql
parent35762251565d6c9660d8402e8fcf655ff55cd315 (diff)
downloadPeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.gz
PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.zst
PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.zip
Fix internal user subscription
Diffstat (limited to 'server/models/video/sql')
-rw-r--r--server/models/video/sql/videos-id-list-query-builder.ts4
1 files changed, 2 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 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 {
367 ' WHERE "videoShare"."videoId" = "video"."id"' + 367 ' WHERE "videoShare"."videoId" = "video"."id"' +
368 ' )' + 368 ' )' +
369 ' OR' + 369 ' OR' +
370 ' EXISTS (' + // Videos published by accounts we follow 370 ' EXISTS (' + // Videos published by channels we follow
371 ' SELECT 1 from "actorFollow" ' + 371 ' SELECT 1 from "actorFollow" ' +
372 ' WHERE "actorFollow"."targetActorId" = "account"."actorId" AND "actorFollow"."actorId" = :followerActorId ' + 372 ' WHERE "actorFollow"."targetActorId" = "videoChannel"."actorId" AND "actorFollow"."actorId" = :followerActorId ' +
373 ' AND "actorFollow"."state" = \'accepted\'' + 373 ' AND "actorFollow"."state" = \'accepted\'' +
374 ' )' 374 ' )'
375 375