aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSebastian <sebasjm@gmail.com>2024-08-01 09:14:50 -0300
committerSebastian <sebasjm@gmail.com>2024-08-01 09:14:50 -0300
commite7ff6cd52c335c3c10ca913140f7a077646e99ac (patch)
tree00e328f25dc5129f71e7873af51a29db143999b8
parentda23d8c94bfe894b9ad3575ec0254a44a03ae9e7 (diff)
missing join-using
-rw-r--r--src/backenddb/pg_lookup_categories.c1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backenddb/pg_lookup_categories.c b/src/backenddb/pg_lookup_categories.c
index 9aea5477..0d7bee66 100644
--- a/src/backenddb/pg_lookup_categories.c
+++ b/src/backenddb/pg_lookup_categories.c
@@ -131,6 +131,7 @@ TMH_PG_lookup_categories (void *cls,
" AS product_count"
" FROM merchant_categories mc"
" JOIN merchant_product_categories mpc"
+ " USING (category_serial)"
" JOIN merchant_instances mi"
" USING (merchant_serial)"
" WHERE mi.merchant_id=$1"