From bd525aaba017deb95415c28ea6725ddc1dae7890 Mon Sep 17 00:00:00 2001
From: Pinapelz <yukais@pinapelz.com>
Date: Wed, 5 Nov 2025 15:54:48 -0800
Subject: fix recent games played sorting to prio date

---
 backend/src/routes/user.ts | 20 ++++++++++++--------
 1 file changed, 12 insertions(+), 8 deletions(-)

(limited to 'backend/src/routes')

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`
-- 
cgit v1.2.3