remove product duplicates for products with count(tags) > 1

1 files changed, 6 insertions, 2 deletions

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)