diff options
Diffstat (limited to 'server/models/video')
-rw-r--r-- | server/models/video/video-abuse.ts | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/server/models/video/video-abuse.ts b/server/models/video/video-abuse.ts index 285fb1fbc..628f1caa6 100644 --- a/server/models/video/video-abuse.ts +++ b/server/models/video/video-abuse.ts | |||
@@ -143,7 +143,8 @@ export enum ScopeNames { | |||
143 | 'SELECT count(DISTINCT "videoAbuse"."id") ' + | 143 | 'SELECT count(DISTINCT "videoAbuse"."id") ' + |
144 | 'FROM "videoAbuse" ' + | 144 | 'FROM "videoAbuse" ' + |
145 | `WHERE CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = "Video->VideoChannel"."accountId" ` + | 145 | `WHERE CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = "Video->VideoChannel"."accountId" ` + |
146 | `OR CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` + | 146 | `OR CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = ` + |
147 | `CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` + | ||
147 | ')' | 148 | ')' |
148 | ), | 149 | ), |
149 | 'countReportsForReportee__deletedVideo' | 150 | 'countReportsForReportee__deletedVideo' |