refactor: don't use query builder

1 files changed, 3 insertions, 7 deletions

diff --git a/src/api/routes/channels/#channel_id/messages/pins/index.ts b/src/api/routes/channels/#channel_id/messages/pins/index.ts

index 3dd10ee49..651a140e2 100644
--- a/src/api/routes/channels/#channel_id/messages/pins/index.ts
+++ b/src/api/routes/channels/#channel_id/messages/pins/index.ts
@@ -56,13 +56,9 @@ router.put(
 		// * in dm channels anyone can pin messages -> only check for guilds
 		if (message.guild_id) req.permission?.hasThrow("MANAGE_MESSAGES");
 
-		const pinned_count = await Message.createQueryBuilder("message")
-			.leftJoinAndSelect("message.channel", "channel")
-			.leftJoinAndSelect("message.author", "author")
-			.where("channel.id = :channelId", { channelId: channel_id })
-			.andWhere("message.pinned_at IS NOT NULL")
-			.orderBy("message.pinned_at", "DESC")
-			.getCount();
+		const pinned_count = await Message.count({
+			where: { channel: { id: channel_id }, pinned_at: Not(IsNull()) },
+		});
 
 		const { maxPins } = Config.get().limits.channel;
 		if (pinned_count >= maxPins)