summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--bin/serve.fnl4
1 files changed, 3 insertions, 1 deletions
diff --git a/bin/serve.fnl b/bin/serve.fnl
index 14073cf..69369fe 100644
--- a/bin/serve.fnl
+++ b/bin/serve.fnl
@@ -150,7 +150,9 @@
(must
(luna.db.query
db
- "SELECT title FROM tags ORDER BY creation_time"
+ "SELECT DISTINCT tags.title FROM tags
+ INNER JOIN product_tags ON product_tags.tag = tags.title
+ ORDER BY creation_time"
[]))))
(fn query-products [{: query : tags : min-price : max-price : price-per : site} page]