select
    pv_challenge_challenge.id as CenterId,
    user.email as Email,
    user.full_name as Name,
    pv_challenge_challenge.start_date as START_DATE,
    pv_challenge_challenge.finish_date as FINISH_DATE,
    sum(pv_challenge_decision.score1) as SCORE1,
    sum(pv_challenge_decision.score2) as SCORE2
from
    user
join
    pv_challenge_challenge on user.id = pv_challenge_challenge.user_id
left join
    pv_challenge_challenge_decision on pv_challenge_challenge.id = pv_challenge_challenge_decision.challenge_id
left join
    pv_challenge_decision on pv_challenge_decision.id = pv_challenge_challenge_decision.decision_id
where
    pv_challenge_challenge.game_session_id in (809, 706, 288)
group by
    pv_challenge_challenge.id,
    user.email,
    user.full_name,
    pv_challenge_challenge.start_date,
    pv_challenge_challenge.finish_date;