From 3b48022af13e17004c693f429636b87b1cc57e94 Mon Sep 17 00:00:00 2001
From: Florian Dold <florian@dold.me>
Date: Mon, 1 Jul 2024 00:32:04 +0200
Subject: sql

---
 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
index a80a19ee..2f3074cf 100644
--- 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");
-- 
cgit v1.2.3