diff options
| -rw-r--r-- | bin/serve.fnl | 8 |
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) |