$news = Doctrine_Query::create() -> select("n.id, n.title, n.time, n.intro, ISNULL(n.text) more, n.comments, a.login") -> from("NewsRecord n") -> innerJoin("n.Author a") -> execute();