aboutsummaryrefslogtreecommitdiff
path: root/src/lib/server/services/references.ts
diff options
context:
space:
mode:
Diffstat (limited to 'src/lib/server/services/references.ts')
-rw-r--r--src/lib/server/services/references.ts4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/lib/server/services/references.ts b/src/lib/server/services/references.ts
index 99ba487..c5b6630 100644
--- a/src/lib/server/services/references.ts
+++ b/src/lib/server/services/references.ts
@@ -1,6 +1,6 @@
import { db as defaultDb } from '$lib/server/db';
import { references } from '$lib/server/db/schema';
-import { eq, desc } from 'drizzle-orm';
+import { eq, desc, asc } from 'drizzle-orm';
import type { AppDatabase } from './groceries';
import type { Reference } from './types';
@@ -12,7 +12,7 @@ export async function loadForGrocery(
.select()
.from(references)
.where(eq(references.groceryId, groceryId))
- .orderBy(desc(references.qualityScore));
+ .orderBy(desc(references.qualityScore), asc(references.id));
}
export async function add(