<?php
// date, event_type, user...
$stmt = $conn->prepare("
  SELECT al.*, bt.reference, ft.description, u.username
  FROM reconciliation_audit_logs al
  JOIN bank_transactions bt ON bt.id = al.bank_transaction_id
  LEFT JOIN financial_transactions ft ON ft.id = al.financial_transaction_id
  JOIN users u ON u.id = al.user_id
  WHERE DATE(al.created_at) BETWEEN ? AND ?
  ORDER BY al.created_at DESC
");
