your tables contain the following relationships:
Orders -> Order details:
Orders.OrderID = OrderDetails.DetailsOrderID
Orders -> Users
Orders.OrderUserID = Users.UserID
The SQL Should be:
SELECT Orders.*, OrderDetails.*, Users.*
FROM Orders
INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.DetailsOrderID
INNER JOIN Users ON Orders.OrderUserID = Users.UserID
WHERE OrderDetails.Platform = 'Nintendo DS' AND Orders.status = '1'