From 812a4170eee4383b5c1f5cd52cb58cc04d50cb36 Mon Sep 17 00:00:00 2001
From: cvium <clausvium@gmail.com>
Date: Fri, 28 Oct 2022 22:38:58 -0400
Subject: Backport pull request #8501 from jellyfin/release-10.8.z

fix: set MinIndexNumber for the next up query

Original-merge: 679e83082f76b0d6c54d0aa4b8fe1138c1a10ccd

Merged-by: Claus Vium <cvium@users.noreply.github.com>

Backported-by: Joshua M. Boniface <joshua@boniface.me>
---
 Emby.Server.Implementations/Data/SqliteItemRepository.cs | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'Emby.Server.Implementations/Data')

diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs
index 7622d2fe6..0ebcd4c0b 100644
--- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs
+++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs
@@ -3524,6 +3524,12 @@ namespace Emby.Server.Implementations.Data
                 statement?.TryBind("@MinIndexNumber", query.MinIndexNumber.Value);
             }
 
+            if (query.MinParentIndexNumber.HasValue)
+            {
+                whereClauses.Add("ParentIndexNumber>=@MinParentIndexNumber");
+                statement?.TryBind("@MinParentIndexNumber", query.MinParentIndexNumber.Value);
+            }
+
             if (query.MinDateCreated.HasValue)
             {
                 whereClauses.Add("DateCreated>=@MinDateCreated");
-- 
cgit v1.2.3