Fix join in video events

1 files changed, 20 insertions, 10 deletions

diff --git a/server/models/request/request-video-event.ts b/server/models/request/request-video-event.ts
index 34d5c7162..d7dce9bc8 100644
--- a/server/models/request/request-video-event.ts
+++ b/server/models/request/request-video-event.ts
@@ -102,15 +102,20 @@ listWithLimitAndRandom = function (limitPods: number, limitRequestsPerPod: numbe
           model: RequestVideoEvent['sequelize'].models.Video,
           include: [
             {
-              model: RequestVideoEvent['sequelize'].models.Author,
+              model: RequestVideoEvent['sequelize'].models.VideoChannel,
               include: [
                 {
-                  model: RequestVideoEvent['sequelize'].models.Pod,
-                  where: {
-                    id: {
-                      $in: podIds
+                  model: RequestVideoEvent['sequelize'].models.Author,
+                  include: [
+                    {
+                      model: RequestVideoEvent['sequelize'].models.Pod,
+                      where: {
+                        id: {
+                          $in: podIds
+                        }
+                      }
                     }
-                  }
+                  ]
                 }
               ]
             }
@@ -138,10 +143,15 @@ removeByRequestIdsAndPod = function (ids: number[], podId: number) {
         model: RequestVideoEvent['sequelize'].models.Video,
         include: [
           {
-            model: RequestVideoEvent['sequelize'].models.Author,
-            where: {
-              podId
-            }
+            model: RequestVideoEvent['sequelize'].models.VideoChannel,
+            include: [
+              {
+                model: RequestVideoEvent['sequelize'].models.Author,
+                where: {
+                  podId
+                }
+              }
+            ]
           }
         ]
       }