$sql = "SELECT o.* FROM (
                    SELECT MAX(o.actualAt) as actualAt, o.team_id, o.match_id, o.bookmaker_id FROM arb_match_odds o
                    WHERE o.match_id = :matchId AND o.resultState = 'win' GROUP BY o.team_id, o.match_id, o.bookmaker_id
                ) newest
                INNER JOIN arb_match_odds o USING(actualAt, team_id, match_id, bookmaker_id)
                WHERE o.resultState = 'win'

                UNION SELECT o.* FROM (
                    SELECT MAX(o.actualAt) as actualAt, o.match_id, o.bookmaker_id FROM arb_match_odds o
                    WHERE o.match_id = :matchId AND o.resultState = 'tie' GROUP BY o.team_id, o.match_id, o.bookmaker_id
                ) newest
                INNER JOIN arb_match_odds o USING(actualAt, match_id, bookmaker_id)
                WHERE o.resultState = 'tie' AND o.team_id IS NULL";

        $rsm = new ResultSetMapping;
        $rsm->addEntityResult('Arb\Bet\MatchOdd', 'o');
        $class = $this->doctrine->getClassMetadata('Arb\Bet\MatchOdd');
        foreach ($class->getColumnNames() as $column) {
            $rsm->addFieldResult('o', $column, $class->getFieldForColumn($column));
        }

        $odds = $this->doctrine->getEntityManager()->createNativeQuery($sql, $rsm);
        $odds->setParameter('matchId', $match->getId());

        dump($odds->getResult());