1SELECT 
2  date as "Kickoff (UTC)",
3  m.competition_name as "Competition",
4  s.season_label as "Season",
5  home_team_name as "Home Team",
6  away_team_name as "Away Team",
7  venue_name as "Venue"
8FROM @blt.ultimate_soccer_dataset.matches m
9LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.seasons" s 
10  ON m.season_id = s.season_id
11LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.competitions" c 
12  ON s.competition_id = c.competition_id
13WHERE status = 'Not Started' AND date >= NOW()
14      and s.season_label = '2026' and c.slug = 'world-cup'
15ORDER BY date ASC, m.competition_name, m.home_team_name, m.away_team_name
16LIMIT 100