diff options
| author | Luke Pulverenti <luke.pulverenti@gmail.com> | 2015-11-16 17:03:11 -0500 |
|---|---|---|
| committer | Luke Pulverenti <luke.pulverenti@gmail.com> | 2015-11-16 17:03:11 -0500 |
| commit | 51d00cf3fd123534995153e4fbc7a3c7a0a8a5c3 (patch) | |
| tree | 47c258c576fea9ef3404f901de93fd01888fc50f /MediaBrowser.Server.Implementations | |
| parent | 79b2415fdf9684ba8e80863d664cd7e9cc57fff4 (diff) | |
update queries
Diffstat (limited to 'MediaBrowser.Server.Implementations')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | 4 |
1 files changed, 2 insertions, 2 deletions
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) |
