diff options
Diffstat (limited to 'src/backenddb/pg_select_open_transfers.c')
-rw-r--r-- | src/backenddb/pg_select_open_transfers.c | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/src/backenddb/pg_select_open_transfers.c b/src/backenddb/pg_select_open_transfers.c index 7113c446..5b2407e3 100644 --- a/src/backenddb/pg_select_open_transfers.c +++ b/src/backenddb/pg_select_open_transfers.c @@ -140,19 +140,21 @@ TMH_PG_select_open_transfers (void *cls, "select_open_transfers", "SELECT" " credit_serial" + ",merchant_id AS instance_id" ",exchange_url" + ",payto_uri" ",wtid" ",credit_amount_val" ",credit_amount_frac" - ",payto_uri" + ",ready_time AS next_attempt" " FROM merchant_transfers" - " JOIN merchant_instances" - " USING (merchant_id)" " JOIN merchant_accounts" " USING (account_serial)" + " JOIN merchant_instances" + " USING (merchant_serial)" " WHERE confirmed AND" " NOT (failed OR verified)" - " ORDER BY next_attempt INC" + " ORDER BY ready_time ASC" " LIMIT $1;"); qs = GNUNET_PQ_eval_prepared_multi_select ( |