fix: prevent language filters to load in non video libraries

1 files changed, 32 insertions, 14 deletions

diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs
index d8fc87ec18..71b46b3cb5 100644
--- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs
+++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs
@@ -517,20 +517,6 @@ public sealed partial class BaseItemRepository
             .OrderBy(r => r)
             .ToArray();
 
-        var subtitleLanguages = context.MediaStreamInfos
-            .Where(s => s.StreamType == MediaStreamTypeEntity.Subtitle)
-            .Select(s => string.IsNullOrEmpty(s.Language) ? "und" : s.Language) // und = undetermined
-            .Distinct()
-            .OrderBy(l => l)
-            .ToArray();
-
-        var audioLanguages = context.MediaStreamInfos
-            .Where(s => s.StreamType == MediaStreamTypeEntity.Audio)
-            .Select(s => string.IsNullOrEmpty(s.Language) ? "und" : s.Language) // und = undetermined
-            .Distinct()
-            .OrderBy(l => l)
-            .ToArray();
-
         var tags = context.ItemValuesMap
             .Where(ivm => ivm.ItemValue.Type == ItemValueType.Tags)
             .Where(ivm => matchingItemIds.Contains(ivm.ItemId))
@@ -549,6 +535,28 @@ public sealed partial class BaseItemRepository
             .OrderBy(g => g)
             .ToArray();
 
+        // At the moment language filters are only available for video types (Movie and Series libraries).
+        // They are fetched directly from the MediaStreamInfos table and only filtered by StreamType.
+        // This is the fastest and most perfomant way to get the list of available languages,
+        // but the filter values can include language tags that are not linked to any item in the current library.
+        var subtitleLanguages = IncludesVideoTypes(filter)
+            ? context.MediaStreamInfos
+                .Where(s => s.StreamType == MediaStreamTypeEntity.Subtitle)
+                .Select(s => string.IsNullOrEmpty(s.Language) ? "und" : s.Language) // und = undetermined
+                .Distinct()
+                .OrderBy(l => l)
+                .ToArray()
+            : [];
+
+        var audioLanguages = IncludesVideoTypes(filter)
+            ? context.MediaStreamInfos
+                .Where(s => s.StreamType == MediaStreamTypeEntity.Audio)
+                .Select(s => string.IsNullOrEmpty(s.Language) ? "und" : s.Language) // und = undetermined
+                .Distinct()
+                .OrderBy(l => l)
+                .ToArray()
+            : [];
+
         return new QueryFiltersLegacy
         {
             Years = years,
@@ -559,4 +567,14 @@ public sealed partial class BaseItemRepository
             AudioLanguages = audioLanguages
         };
     }
+
+    private bool IncludesVideoTypes(InternalItemsQuery filter)
+    {
+        return filter.IncludeItemTypes.Contains(BaseItemKind.Movie)
+            || filter.IncludeItemTypes.Contains(BaseItemKind.Video)
+            || filter.IncludeItemTypes.Contains(BaseItemKind.Series)
+            || filter.IncludeItemTypes.Contains(BaseItemKind.Season)
+            || filter.IncludeItemTypes.Contains(BaseItemKind.Episode)
+            || filter.IncludeItemTypes.Contains(BaseItemKind.Trailer);
+    }
 }