fix recent games played sorting to prio date

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`