I believe, by `transaction_email` you meant customer email and by `transaction status` you meant a way to identify whether order was placed successfully or not. Customer email is present in `sales_order` table. Generally when you click the "Place Order" button, order status is `pending` and when you make the payment successfully, order status changes to `processing`. You can get order status from `sales_order` table. Here is the sql query for the same: SELECT spt.order_id, spt.transaction_id, spt.txn_id, so.customer_email, so.status from sales_payment_transaction as spt join sales_order as so on spt.order_id = so.entity_id;