From 0b96a0fb77cee07abac185fb1fb704388498631b Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Thu, 12 Jan 2023 11:11:30 +0100 Subject: Optimize again comments list sql query --- server/models/shared/sort.ts | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'server/models/shared') diff --git a/server/models/shared/sort.ts b/server/models/shared/sort.ts index 77e84dcf4..a9a093099 100644 --- a/server/models/shared/sort.ts +++ b/server/models/shared/sort.ts @@ -49,7 +49,7 @@ function getCommentSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): if (field === 'totalReplies') { return [ - [ Sequelize.literal('"totalReplies"'), direction ], + [ 'totalReplies', direction ], lastSort ] } -- cgit v1.2.3