diff options
| author | unwox <me@unwox.com> | 2024-11-02 15:09:06 +0600 |
|---|---|---|
| committer | unwox <me@unwox.com> | 2024-11-02 15:09:06 +0600 |
| commit | f385fe92890da1a19a768ca27241b63a1078dc3f (patch) | |
| tree | bb5534e2b5709c14ae59abada8535053e8e98db8 /bin | |
| parent | 5574f9b98782d52ac1a2a212b37ab0788fec446e (diff) | |
fix pagination
Diffstat (limited to 'bin')
| -rw-r--r-- | bin/serve.fnl | 36 |
1 files changed, 20 insertions, 16 deletions
diff --git a/bin/serve.fnl b/bin/serve.fnl index 835a49b..5b08e55 100644 --- a/bin/serve.fnl +++ b/bin/serve.fnl @@ -129,14 +129,16 @@ (local the-number (* (tonumber (os.date "%Y%m%d")) limit)) (local total (. (must (luna.db.query db - "SELECT count(*) - FROM products - INNER JOIN product_tags ON product_tags.product = products.url - WHERE archived = false - AND product_tags.tag IN ('Красный чай', 'Улун', 'Шен пуэр', - 'Шу пуэр', 'Зеленый чай', 'Белый чай', - 'Желтый чай') - GROUP BY products.url" [])) + "SELECT count(ROWID) + FROM ( + SELECT products.ROWID + FROM products + INNER JOIN product_tags ON product_tags.product = products.url + WHERE archived = false + AND product_tags.tag IN ('Красный чай', 'Улун', 'Шен пуэр', + 'Шу пуэр', 'Зеленый чай', 'Белый чай', + 'Желтый чай') + GROUP BY products.url)" [])) 1 1)) (must (luna.db.query* @@ -215,14 +217,16 @@ (luna.db.query db (string.format - "SELECT count(*) - FROM search - INNER JOIN products ON search.fid = products.url - LEFT JOIN product_tags ON product_tags.product = search.fid - WHERE search.`table` = 'products' - AND products.archived = false - %s - GROUP BY products.url" where-sql) + "SELECT count(ROWID) + FROM ( + SELECT products.ROWID + FROM search + INNER JOIN products ON search.fid = products.url + LEFT JOIN product_tags ON product_tags.product = search.fid + WHERE search.`table` = 'products' + AND products.archived = false + %s + GROUP BY products.url)" where-sql) where-vars))) {:results |