From 186a9e267815e7caa62391fdc7b8cbd842922610 Mon Sep 17 00:00:00 2001
From: Leonardo Bishop <me@leonardobishop.net>
Date: Tue, 9 Sep 2025 23:38:41 +0100
Subject: Pass config to api and fix bad join

---
 pkg/database/query/entries.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'pkg/database/query/entries.sql')

diff --git a/pkg/database/query/entries.sql b/pkg/database/query/entries.sql
index 1927468..1f39016 100644
--- a/pkg/database/query/entries.sql
+++ b/pkg/database/query/entries.sql
@@ -7,5 +7,5 @@ RETURNING *;
 
 -- name: GetEntries :many
 SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji as kind_emoji FROM entries
-JOIN kinds ON entries.id == kinds.id
+JOIN kinds ON entries.kind == kinds.id
 ORDER BY timestamp DESC;
-- 
cgit v1.2.3-70-g09d2

