On Wed, May 14, 2008 at 1:10 PM, Alex <outroa...@gmail.com> wrote:
>  $query = Doctrine_Query::create()->from('CommentItem
> c')->leftJoin('c.sfGuardUser u')->leftJoin('c.VoteComment vc with vc.user_id
> = '.$this->getUser()->getId());
>     }

>     $treeObject = $commentTable->getTree();
>     $treeObject->setBaseQuery($query);

>     echo $treeObject->getBaseQuery()->getSqlQuery();

> Output is

> "SELECT c.id AS c__id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS
> c__level, c.root_id AS c__root_id FROM comments c LEFT JOIN sf_guard_user s
> ON c.user_id = s.id LEFT JOIN votes v ON c.id = v.comment_id WHERE (v.type
> = 2 OR v.type IS NULL)"

> Doctrine seems to be discarding my last leftJoin's with condition. Is this
> a bug or am I doing something wrong?
> --

> - Alex