aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models/abuse/abuse-query-builder.ts
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2020-08-26 15:44:19 +0200
committerChocobozzz <me@florianbigard.com>2020-08-26 15:44:19 +0200
commit6055411221fdbd1ae51a9f4171fc626f5ef1dd15 (patch)
tree22dd555bb3a03391857c52d2cfbcd7d532f69061 /server/models/abuse/abuse-query-builder.ts
parentbddada385a05d81963b75e81c734d53265bc9b15 (diff)
downloadPeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.tar.gz
PeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.tar.zst
PeerTube-6055411221fdbd1ae51a9f4171fc626f5ef1dd15.zip
Fix abuse reportee search query
Diffstat (limited to 'server/models/abuse/abuse-query-builder.ts')
-rw-r--r--server/models/abuse/abuse-query-builder.ts2
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 ]