diff options
| -rw-r--r-- | backend/src/routes/user.ts | 20 |
1 files changed, 12 insertions, 8 deletions
diff --git a/backend/src/routes/user.ts b/backend/src/routes/user.ts index 96a452e..3019da7 100644 --- a/backend/src/routes/user.ts +++ b/backend/src/routes/user.ts @@ -24,14 +24,18 @@ export const handleMeRoute = async (req: express.Request, res: express.Response) select: { id: true, username: true, isAdmin: true, bio: true } }); const recentPlayedGames: RecentPlayedGame[] = await prisma.$queryRaw` - SELECT DISTINCT ON (s."gameInternalName") - g."formattedName", - s."gameInternalName", - s."timestamp" - FROM "Score" s - INNER JOIN "Game" g ON g."internalName" = s."gameInternalName" - WHERE s."userId" = ${parseInt(userId as string)} - ORDER BY s."gameInternalName", s."timestamp" DESC + SELECT * + FROM ( + SELECT DISTINCT ON (s."gameInternalName") + g."formattedName", + s."timestamp", + s."gameInternalName" + FROM "Score" s + INNER JOIN "Game" g ON g."internalName" = s."gameInternalName" + WHERE s."userId" = ${parseInt(userId as string)} + ORDER BY s."gameInternalName", s."timestamp" DESC + ) sub + ORDER BY sub."timestamp" DESC LIMIT 5; `; const scoreCountByGame: SafeGameCount[] = await prisma.$queryRaw` |