merchant

commit 8288ed0bca06dd6795b5513ad870d31f7e87fb47
parent 9db3b869e49c3be47e4f4fd0aaf51a12d645b90f
Author: Christian Grothoff <christian@grothoff.org>
Date:   Tue, 23 Sep 2025 22:13:32 +0200

-fix SQL

Diffstat:
M
src/backenddb/pg_select_donau_instances.c
 | 
4
+++-

1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/src/backenddb/pg_select_donau_instances.c b/src/backenddb/pg_select_donau_instances.c
@@ -162,7 +162,9 @@ select_all_donau_instances (void *cls,
            ",dk.keys_json"
            " FROM merchant_donau_instances di"
            " JOIN merchant_donau_keys dk"
-           "   ON di.donau_url = dk.donau_url");
+           "   ON di.donau_url = dk.donau_url"
+           " JOIN merchant_instances mi"
+           "   ON di.merchant_instance_serial = mi.merchant_serial");
   qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn,
                                              "select_all_donau_instances",
                                              params,