diff options
author | Chocobozzz <me@florianbigard.com> | 2021-12-17 14:42:31 +0100 |
---|---|---|
committer | Chocobozzz <me@florianbigard.com> | 2021-12-17 14:42:31 +0100 |
commit | 9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a (patch) | |
tree | ff118bf9f733d19b28abd6ff35fb76fa236c0101 /server | |
parent | 35762251565d6c9660d8402e8fcf655ff55cd315 (diff) | |
download | PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.gz PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.zst PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.zip |
Fix internal user subscription
Diffstat (limited to 'server')
-rw-r--r-- | server/models/video/sql/videos-id-list-query-builder.ts | 4 |
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 | ||