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/models/video | |
| parent | 35762251565d6c9660d8402e8fcf655ff55cd315 (diff) | |
| download | PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.gz PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.tar.zst PeerTube-9e2789aa4bcd582d6e7746e2f6ece0fd25a3240a.zip | |
Fix internal user subscription
Diffstat (limited to 'server/models/video')
| -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 | ||