$q->select('i.name,i.id,g.id,g.name,t.id') ->from('Transaction t') ->leftJoin('t.Item i') ->leftJoin('i.Game g') ->leftJoin('i.User u ON t.buyer_id = u.id') ->where('t.buyer_id = ?') ->execute(array($this->getUser()->getId()));