From 3c79c2ce86eaf9e151ab6c2c9d1f646968a16744 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 11 Jun 2021 11:27:45 +0200 Subject: Optimize join build --- server/models/video/sql/video-model-get-query-builder.ts | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'server/models/video/sql/video-model-get-query-builder.ts') diff --git a/server/models/video/sql/video-model-get-query-builder.ts b/server/models/video/sql/video-model-get-query-builder.ts index 892639076..4aab9ff1d 100644 --- a/server/models/video/sql/video-model-get-query-builder.ts +++ b/server/models/video/sql/video-model-get-query-builder.ts @@ -52,7 +52,6 @@ export class VideosModelGetQueryBuilder { export class VideosModelGetQuerySubBuilder extends AbstractVideosModelQueryBuilder { protected attributes: { [key: string]: string } - protected joins: string[] = [] protected webtorrentFilesQuery: string protected streamingPlaylistFilesQuery: string @@ -102,6 +101,6 @@ export class VideosModelGetQuerySubBuilder extends AbstractVideosModelQueryBuild const order = 'ORDER BY "Tags"."name" ASC' const from = `SELECT * FROM "video" ${this.where} LIMIT 1` - return `${this.buildSelect()} FROM (${from}) AS "video" ${this.joins.join(' ')} ${order}` + return `${this.buildSelect()} FROM (${from}) AS "video" ${this.joins} ${order}` } } -- cgit v1.2.3