From 51d00cf3fd123534995153e4fbc7a3c7a0a8a5c3 Mon Sep 17 00:00:00 2001 From: Luke Pulverenti Date: Mon, 16 Nov 2015 17:03:11 -0500 Subject: update queries --- .../Persistence/SqliteItemRepository.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'MediaBrowser.Server.Implementations') diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index d414ce7c1..89507a021 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -1954,14 +1954,14 @@ namespace MediaBrowser.Server.Implementations.Persistence if (query.TopParentIds.Length == 1) { - whereClauses.Add("(TopParentId is null or TopParentId=@TopParentId)"); + whereClauses.Add("(TopParentId=@TopParentId)"); cmd.Parameters.Add(cmd, "@TopParentId", DbType.String).Value = query.TopParentIds[0]; } if (query.TopParentIds.Length > 1) { var val = string.Join(",", query.TopParentIds.Select(i => "'" + i + "'").ToArray()); - whereClauses.Add("(TopParentId is null or TopParentId in (" + val + "))"); + whereClauses.Add("(TopParentId in (" + val + "))"); } if (query.AncestorIds.Length == 1) -- cgit v1.2.3