diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 10:39:32 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 10:39:32 +0900 |
| commit | d7e7848c9206b68ab86d2d566ec4247db87827c0 (patch) | |
| tree | 02f87fd2ef38ebc045f2c32298048cde99c3f48d /src/server/api/endpoints/notes/replies.ts | |
| parent | clean up など (diff) | |
| download | sharkey-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/replies.ts')
| -rw-r--r-- | src/server/api/endpoints/notes/replies.ts | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/server/api/endpoints/notes/replies.ts b/src/server/api/endpoints/notes/replies.ts index 5ac663d77a..0979d2e7e9 100644 --- a/src/server/api/endpoints/notes/replies.ts +++ b/src/server/api/endpoints/notes/replies.ts @@ -59,11 +59,11 @@ export const meta = { export default define(meta, async (ps, user) => { const query = makePaginationQuery(Notes.createQueryBuilder('note'), ps.sinceId, ps.untilId) .andWhere('note.replyId = :replyId', { replyId: ps.noteId }) - .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); |