diff options
| author | Chocobozzz <me@florianbigard.com> | 2020-08-26 15:44:19 +0200 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2020-08-26 15:44:19 +0200 |
| commit | 6055411221fdbd1ae51a9f4171fc626f5ef1dd15 (patch) | |
| tree | 22dd555bb3a03391857c52d2cfbcd7d532f69061 | |
| parent | bddada385a05d81963b75e81c734d53265bc9b15 (diff) | |
| download | PeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.tar.gz PeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.tar.zst PeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.zip | |
Fix abuse reportee search query
| -rw-r--r-- | server/models/abuse/abuse-query-builder.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/abuse/abuse-query-builder.ts b/server/models/abuse/abuse-query-builder.ts index 9d7cb75aa..532459144 100644 --- a/server/models/abuse/abuse-query-builder.ts +++ b/server/models/abuse/abuse-query-builder.ts | |||
| @@ -42,7 +42,7 @@ function buildAbuseListQuery (options: BuildAbusesQueryOptions, type: 'count' | | |||
| 42 | 'LEFT JOIN "videoBlacklist" ON "videoBlacklist"."videoId" = "video"."id"', | 42 | 'LEFT JOIN "videoBlacklist" ON "videoBlacklist"."videoId" = "video"."id"', |
| 43 | 'LEFT JOIN "videoChannel" ON "video"."channelId" = "videoChannel"."id"', | 43 | 'LEFT JOIN "videoChannel" ON "video"."channelId" = "videoChannel"."id"', |
| 44 | 'LEFT JOIN "account" "reporterAccount" ON "reporterAccount"."id" = "abuse"."reporterAccountId"', | 44 | 'LEFT JOIN "account" "reporterAccount" ON "reporterAccount"."id" = "abuse"."reporterAccountId"', |
| 45 | 'LEFT JOIN "account" "flaggedAccount" ON "flaggedAccount"."id" = "abuse"."reporterAccountId"', | 45 | 'LEFT JOIN "account" "flaggedAccount" ON "flaggedAccount"."id" = "abuse"."flaggedAccountId"', |
| 46 | 'LEFT JOIN "commentAbuse" ON "commentAbuse"."abuseId" = "abuse"."id"', | 46 | 'LEFT JOIN "commentAbuse" ON "commentAbuse"."abuseId" = "abuse"."id"', |
| 47 | 'LEFT JOIN "videoComment" ON "commentAbuse"."videoCommentId" = "videoComment"."id"' | 47 | 'LEFT JOIN "videoComment" ON "commentAbuse"."videoCommentId" = "videoComment"."id"' |
| 48 | ] | 48 | ] |