I am trying to get all
transaction status by SQL query.
I found the table where all transactions are stored
So I can easily get all
transactions and 'transactions_id'
but how can I get
SELECT spt.transaction_id, spt.txn_id, spt.is_closed, so.customer_email FROM sales_payment_transaction spt INNER JOIN sales_order so on spt.order_id = so.entity_id;
Is that right?