1 files changed, 5 insertions, 0 deletions

diff --git a/server/models/video/video.ts b/server/models/video/video.ts
index 199ea9ea4..3f282580c 100644
--- a/server/models/video/video.ts
+++ b/server/models/video/video.ts
@@ -425,6 +425,11 @@ type AvailableForListIDsOptions = {
           userId: options.historyOfUser.id
         }
       })
+
+      // Even if the relation is n:m, we know that a user only have 0..1 video history
+      // So we won't have multiple rows for the same video
+      // Without this, we would not be able to sort on "updatedAt" column of UserVideoHistoryModel
+      query.subQuery = false
     }
 
     return query