From 5574f9b98782d52ac1a2a212b37ab0788fec446e Mon Sep 17 00:00:00 2001
From: unwox <me@unwox.com>
Date: Sat, 2 Nov 2024 14:59:51 +0600
Subject: remove product duplicates for products with count(tags) > 1

---
 bin/serve.fnl | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'bin')

diff --git a/bin/serve.fnl b/bin/serve.fnl
index 1d08dee..835a49b 100644
--- a/bin/serve.fnl
+++ b/bin/serve.fnl
@@ -135,7 +135,8 @@
                 WHERE archived = false
                 AND product_tags.tag IN ('Красный чай', 'Улун', 'Шен пуэр',
                                          'Шу пуэр', 'Зеленый чай', 'Белый чай',
-                                         'Желтый чай')" []))
+                                         'Желтый чай')
+                GROUP BY products.url" []))
        1 1))
   (must
     (luna.db.query*
@@ -153,6 +154,7 @@
       WHERE products.archived = false
       AND product_tags.tag IN ('Красный чай', 'Улун', 'Шен пуэр', 'Шу пуэр',
                                'Зеленый чай', 'Белый чай', 'Желтый чай')
+      GROUP BY products.url
       ORDER BY ROW_NUMBER() over (PARTITION BY site ORDER BY products.ROWID)
       LIMIT ?
       OFFSET ?"
@@ -219,7 +221,8 @@
         LEFT JOIN product_tags ON product_tags.product = search.fid
         WHERE search.`table` = 'products'
         AND   products.archived = false
-        %s" where-sql)
+        %s
+        GROUP BY products.url" where-sql)
      where-vars)))
 
   {:results
@@ -241,6 +244,7 @@
        WHERE search.`table` = 'products'
        AND   products.archived = false
        %s
+       GROUP BY products.url
        ORDER BY ROW_NUMBER() over (PARTITION BY products.site ORDER BY products.ROWID),
                 rank
        LIMIT 48 OFFSET ?" where-sql)
-- 
cgit v1.2.3