select home_teams.name as home_team, away_teams.name as away_team, matches.date, odds.*
from @blt.ultimate_soccer_dataset.matches matches
inner join @blt.ultimate_soccer_dataset.teams home_teams ON (matches.home_team_id = home_teams.team_id)
inner join @blt.ultimate_soccer_dataset.teams away_teams ON (matches.away_team_id = away_teams.team_id)
inner join @blt.ultimate_soccer_dataset.seasons s ON (matches.season_id = s.season_id)
inner join @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
inner join @blt.ultimate_soccer_dataset.match_betting_odds odds ON (odds.match_id = matches.match_id)
where 1=1
      and c.name = 'FIFA Club World Cup'
      and year(s.start_date) = 2025
      --and matches.match_id = '2e5ba4f4-a5f5-5bed-8f2c-90d1f8f81d68'
      and market = 'Match Winner'
order by matches.date, matches.match_id, collected_at, bookmaker, outcome