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 c.slug = 'premier-league' and s.season_label = '2025/2026' and c.country = 'England'
15ORDER BY date ASC, m.competition_name, m.home_team_name, m.away_team_name
16LIMIT 100