SELECT COUNT(bet)
from User user
join user.bets bet
join bet.match match
join match.competition competition
where user.id= :userId and competition.id= :competitionId and  bet.value IS EMPTY;