$query = "SELECT orders.*, urunler.*, account.*
    FROM orders
    INNER JOIN urunler ON orders.ordersProductID = urunler.urun_id
    INNER JOIN account ON orders.ordersAccountID = account.accountID
    WHERE orders.ordersNumber = :ordersNumber
    AND orders.ordersStatus = 2";