merchant

commit 3b48022af13e17004c693f429636b87b1cc57e94
parent e4991a240859eb202967e6863abeb63e3dec5721
Author: Florian Dold <florian@dold.me>
Date:   Mon,  1 Jul 2024 00:32:04 +0200

sql

Diffstat:
M
src/backenddb/pg_lookup_all_products.c
 | 
6
+++---

1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/backenddb/pg_lookup_all_products.c b/src/backenddb/pg_lookup_all_products.c
@@ -164,19 +164,19 @@ TMH_PG_lookup_all_products (void *cls,
            ",total_sold"
            ",total_lost"
            ",image"
-           ",merchant_inventory.address"
+           ",minv.address"
            ",next_restock"
            ",minimum_age"
            ",product_id"
            ",product_serial"
-           " FROM merchant_inventory mi"
+           " FROM merchant_inventory minv"
            " JOIN merchant_instances inst"
            "   USING (merchant_serial)"
            ",LATERAL ("
            "   SELECT ARRAY ("
            "     SELECT mpc.category_serial"
            "       FROM merchant_product_categories mpc"
-           "      WHERE mpc.product_serial = mi.product_serial"
+           "      WHERE mpc.product_serial = minv.product_serial"
            "   ) AS category_array"
            " ) t"
            " WHERE inst.merchant_id=$1");