merchant

commit 873b48b5aabe28acbf0aeb274cd946fc1207b894
parent e7ff6cd52c335c3c10ca913140f7a077646e99ac
Author: Sebastian <sebasjm@gmail.com>
Date:   Thu,  1 Aug 2024 09:32:51 -0300

also bring categories without products

Diffstat:
M
src/backenddb/pg_lookup_categories.c
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/backenddb/pg_lookup_categories.c b/src/backenddb/pg_lookup_categories.c
@@ -130,7 +130,7 @@ TMH_PG_lookup_categories (void *cls,
            ",COALESCE(COUNT(mpc.product_serial),0)"
            "   AS product_count"
            " FROM merchant_categories mc"
-           " JOIN merchant_product_categories mpc"
+           " LEFT JOIN merchant_product_categories mpc"
            "   USING (category_serial)"
            " JOIN merchant_instances mi"
            "   USING (merchant_serial)"