List Transactions Needing Attention

This query retrieves all transactions with a status of needs_attention along with relevant details from the customers and subscriptions tables.

      SELECT
  t.id AS transaction_id,
  t.currency_code,
  t.amount,
  t.id_at_gateway,
  t.status AS transaction_status,
  c.id AS customer_id,
  c.name AS customer_name,
  c.email AS customer_email,
  s.id AS subscription_id,
  s.status AS subscription_status
FROM
  transactions t
  LEFT JOIN customers c ON t.customer_id = c.id
  LEFT JOIN subscriptions s ON t.subscription_id = s.id
WHERE
  t.status = 'needs_attention';