summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/notes/children.ts
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2021-03-21 10:39:32 +0900
committersyuilo <Syuilotan@yahoo.co.jp>2021-03-21 10:39:32 +0900
commitd7e7848c9206b68ab86d2d566ec4247db87827c0 (patch)
tree02f87fd2ef38ebc045f2c32298048cde99c3f48d /src/server/api/endpoints/notes/children.ts
parentclean up など (diff)
downloadsharkey-d7e7848c9206b68ab86d2d566ec4247db87827c0.tar.gz
sharkey-d7e7848c9206b68ab86d2d566ec4247db87827c0.tar.bz2
sharkey-d7e7848c9206b68ab86d2d566ec4247db87827c0.zip
fix(server): Use inner join
https://github.com/syuilo/misskey/issues/6813#issuecomment-803400023
Diffstat (limited to 'src/server/api/endpoints/notes/children.ts')
-rw-r--r--src/server/api/endpoints/notes/children.ts10
1 files changed, 5 insertions, 5 deletions
diff --git a/src/server/api/endpoints/notes/children.ts b/src/server/api/endpoints/notes/children.ts
index a8b239e445..4a03ae2d39 100644
--- a/src/server/api/endpoints/notes/children.ts
+++ b/src/server/api/endpoints/notes/children.ts
@@ -64,11 +64,11 @@ export default define(meta, async (ps, user) => {
}));
}));
}))
- .leftJoinAndSelect('note.user', 'user')
- .leftJoinAndSelect('note.reply', 'reply')
- .leftJoinAndSelect('note.renote', 'renote')
- .leftJoinAndSelect('reply.user', 'replyUser')
- .leftJoinAndSelect('renote.user', 'renoteUser');
+ .innerJoinAndSelect('note.user', 'user')
+ .innerJoinAndSelect('note.reply', 'reply')
+ .innerJoinAndSelect('note.renote', 'renote')
+ .innerJoinAndSelect('reply.user', 'replyUser')
+ .innerJoinAndSelect('renote.user', 'renoteUser');
generateVisibilityQuery(query, user);
if (user) generateMutedUserQuery(query, user);