2 files changed, 6 insertions, 2 deletions
diff --git a/internal/db/files.sql.go b/internal/db/files.sql.go
index b45731098..39def271f 100644
--- a/internal/db/files.sql.go
+++ b/internal/db/files.sql.go
@@ -97,7 +97,9 @@ func (q *Queries) GetFile(ctx context.Context, id string) (File, error) {
 const getFileByPathAndSession = `-- name: GetFileByPathAndSession :one
 SELECT id, session_id, path, content, version, created_at, updated_at
 FROM files
-WHERE path = ? AND session_id = ? LIMIT 1
+WHERE path = ? AND session_id = ?
+ORDER BY created_at DESC
+LIMIT 1
 `
 
 type GetFileByPathAndSessionParams struct {
diff --git a/internal/db/sql/files.sql b/internal/db/sql/files.sql
index c2e799076..aba2a6111 100644
--- a/internal/db/sql/files.sql
+++ b/internal/db/sql/files.sql
@@ -6,7 +6,9 @@ WHERE id = ? LIMIT 1;
 -- name: GetFileByPathAndSession :one
 SELECT *
 FROM files
-WHERE path = ? AND session_id = ? LIMIT 1;
+WHERE path = ? AND session_id = ?
+ORDER BY created_at DESC
+LIMIT 1;
 
 -- name: ListFilesBySession :many
 SELECT *