diff options
| author | Chocobozzz <me@florianbigard.com> | 2023-01-12 11:11:30 +0100 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2023-01-12 11:11:41 +0100 |
| commit | 0b96a0fb77cee07abac185fb1fb704388498631b (patch) | |
| tree | 5aa81598d5a1a32646c7c7af66be6e169a79d949 /server/models/shared | |
| parent | 3f3530c3dbc5339b4cba53710b8568b4ad39152e (diff) | |
| download | PeerTube-0b96a0fb77cee07abac185fb1fb704388498631b.tar.gz PeerTube-0b96a0fb77cee07abac185fb1fb704388498631b.tar.zst PeerTube-0b96a0fb77cee07abac185fb1fb704388498631b.zip | |
Optimize again comments list sql query
Diffstat (limited to 'server/models/shared')
| -rw-r--r-- | server/models/shared/sort.ts | 2 |
1 files changed, 1 insertions, 1 deletions
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' ]): | |||
| 49 | 49 | ||
| 50 | if (field === 'totalReplies') { | 50 | if (field === 'totalReplies') { |
| 51 | return [ | 51 | return [ |
| 52 | [ Sequelize.literal('"totalReplies"'), direction ], | 52 | [ 'totalReplies', direction ], |
| 53 | lastSort | 53 | lastSort |
| 54 | ] | 54 | ] |
| 55 | } | 55 | } |