Something

    $product = Doctrine_Query::create() -> from("Product p")                                        -> leftJoin("p.Category cat")                                        -> leftJoin("p.Company c")                                        -> innerJoin("c.ProductManager pm")                                        -> where("p.id = ?")                                        -> fetchOne(array($rd -> getParameter("id")));