+ 'INNER JOIN "account" ON ' +
+ '"videoChannel"."accountId" = "Video->VideoChannel"."accountId" ' +
+ `OR "videoChannel"."accountId" = CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` +
+ ')'
+ ),
+ 'countReportsForReportee__video'
+ ],
+ [
+ literal(
+ '(' +
+ 'SELECT count(DISTINCT "videoAbuse"."id") ' +
+ 'FROM "videoAbuse" ' +
+ `WHERE CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = "Video->VideoChannel"."accountId" ` +
+ `OR CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = ` +
+ `CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` +