From 00b08c0b32b3c8fa36330d72e4a25c7b157de4e3 Mon Sep 17 00:00:00 2001
From: Shadowghost <Ghost_of_Stone@web.de>
Date: Sun, 3 May 2026 13:26:30 +0200
Subject: Omit BoxSet related materialization

---
 .../Item/BaseItemRepository.TranslateQuery.cs           | 17 +++++++----------
 1 file changed, 7 insertions(+), 10 deletions(-)

(limited to 'Jellyfin.Server.Implementations/Item/BaseItemRepository.TranslateQuery.cs')

diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.TranslateQuery.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.TranslateQuery.cs
index 9a57691fbd..0abe981af8 100644
--- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.TranslateQuery.cs
+++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.TranslateQuery.cs
@@ -471,16 +471,13 @@ public sealed partial class BaseItemRepository
                         .Select(g => g.Key)
                     : Enumerable.Empty<Guid>().AsQueryable();
 
-                // BoxSet: played = all children played
-                IEnumerable<Guid> playedBoxSetIds = [];
-                if (hasBoxSet)
-                {
-                    var boxSetIds = baseQuery.Where(e => e.Type == boxSetTypeName).Select(e => e.Id).ToList();
-                    var playedCounts = GetPlayedAndTotalCountBatch(boxSetIds, filter.User!);
-                    playedBoxSetIds = playedCounts
-                        .Where(kvp => kvp.Value.Total > 0 && kvp.Value.Played == kvp.Value.Total)
-                        .Select(kvp => kvp.Key);
-                }
+                // BoxSet: played = all children played.
+                IQueryable<Guid> playedBoxSetIds = hasBoxSet
+                    ? GetFullyPlayedFolderIdsQuery(
+                        context,
+                        baseQuery.Where(e => e.Type == boxSetTypeName).Select(e => e.Id),
+                        filter.User!)
+                    : Enumerable.Empty<Guid>().AsQueryable();
 
                 // Non-folder items: check UserData directly
                 var playedItemIds = context.UserData
-- 
cgit v1.2.3