revert the last bits of the getcount experiment

1 files changed, 4 insertions, 15 deletions

diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs
index bd5a3e30b..7cee309d0 100644
--- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs
+++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs
@@ -2621,21 +2621,10 @@ namespace Emby.Server.Implementations.Data
                 query.Limit = query.Limit.Value + 4;
             }
 
-            var commandText = "select ";
-            if (EnableGroupByPresentationUniqueKey(query))
-            {
-                commandText += "count (distinct PresentationUniqueKey)";
-            }
-            else if (query.GroupBySeriesPresentationUniqueKey)
-            {
-                commandText += "count (distinct SeriesPresentationUniqueKey)";
-            }
-            else
-            {
-                commandText += "count (guid)";
-            }
-
-            commandText += GetFromText() + GetJoinUserDataText(query);
+            var commandText = "select "
+                              + string.Join(',', GetFinalColumnsToSelect(query, new[] { "count(distinct PresentationUniqueKey)" }))
+                              + GetFromText()
+                              + GetJoinUserDataText(query);
 
             var whereClauses = GetWhereClauses(query, null);
             if (whereClauses.Count != 0)