Optimize videos list SQL query

1 files changed, 8 insertions, 1 deletions

diff --git a/server/models/video/video.ts b/server/models/video/video.ts
index fec3dcc20..87ad80caf 100644
--- a/server/models/video/video.ts
+++ b/server/models/video/video.ts
@@ -452,7 +452,14 @@ export type AvailableForListIDsOptions = {
                 'SELECT "videoShare"."videoId" AS "id" FROM "videoShare" ' +
                 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' +
                 'WHERE "actorFollow"."actorId" = ' + actorIdNumber +
-                ' UNION ALL ' +
+                ')'
+              )
+            }
+          },
+          {
+            id: {
+              [ Op.in ]: Sequelize.literal(
+                '(' +
                 'SELECT "video"."id" AS "id" FROM "video" ' +
                 'INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" ' +
                 'INNER JOIN "account" ON "account"."id" = "videoChannel"."accountId" ' +