SELECT u.username, o.order_id, o.order_date, o.total_amount FROM users u LEFT JOIN orders o ON u.user_id = o.user_id WHERE u.is_active = TRUE ORDER BY o.order_date DESC;