Public feed
#888475
$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()));