exchange

commit 849ee6fc89a301e071f1be5e2ea02489cd8df3be
parent 335f6b580a10a5867983a9c232d81420ac000cff
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Sat, 18 Jul 2026 03:01:47 +0200

fix SQL query

Diffstat:
M
src/exchangedb/select_kyc_accounts.c
 | 
2
++

1 file changed, 2 insertions(+), 0 deletions(-)
diff --git a/src/exchangedb/select_kyc_accounts.c b/src/exchangedb/select_kyc_accounts.c
@@ -179,6 +179,8 @@ TALER_EXCHANGEDB_select_kyc_accounts (
            ",COALESCE((lo.jproperties ->> 'HIGH_RISK_CUSTOMER')::bool,FALSE) AS high_risk"
            ",wt.payto_uri"
            " FROM kyc_targets kt"
+           " LEFT JOIN legitimization_outcomes lo"
+           "   ON (lo.h_payto = kt.h_normalized_payto)"
            " LEFT JOIN LATERAL ("
            "   SELECT payto_uri"
            "     FROM wire_targets"