diff options
Diffstat (limited to 'server/models/utils.ts')
-rw-r--r-- | server/models/utils.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/utils.ts b/server/models/utils.ts index 143c1a23c..5337ae75d 100644 --- a/server/models/utils.ts +++ b/server/models/utils.ts | |||
@@ -134,7 +134,7 @@ function buildBlockedAccountSQL (blockerIds: number[]) { | |||
134 | const blockerIdsString = blockerIds.join(', ') | 134 | const blockerIdsString = blockerIds.join(', ') |
135 | 135 | ||
136 | return 'SELECT "targetAccountId" AS "id" FROM "accountBlocklist" WHERE "accountId" IN (' + blockerIdsString + ')' + | 136 | return 'SELECT "targetAccountId" AS "id" FROM "accountBlocklist" WHERE "accountId" IN (' + blockerIdsString + ')' + |
137 | ' UNION ALL ' + | 137 | ' UNION ' + |
138 | 'SELECT "account"."id" AS "id" FROM account INNER JOIN "actor" ON account."actorId" = actor.id ' + | 138 | 'SELECT "account"."id" AS "id" FROM account INNER JOIN "actor" ON account."actorId" = actor.id ' + |
139 | 'INNER JOIN "serverBlocklist" ON "actor"."serverId" = "serverBlocklist"."targetServerId" ' + | 139 | 'INNER JOIN "serverBlocklist" ON "actor"."serverId" = "serverBlocklist"."targetServerId" ' + |
140 | 'WHERE "serverBlocklist"."accountId" IN (' + blockerIdsString + ')' | 140 | 'WHERE "serverBlocklist"."accountId" IN (' + blockerIdsString + ')' |