1SELECT
2 m.date AS match_date,
3 m.home_team_name,
4 m.away_team_name,
5 m.status,
6 m.competition_name
7FROM
8 "@blt.ultimate_soccer_dataset.matches" m
9WHERE
10 m.competition_name = 'UEFA Champions League'
11 AND m.date >= NOW()
12ORDER BY
13 m.date ASC
14LIMIT
15 50| match_date | home_team_name | away_team_name | status | competition_name |
|---|---|---|---|---|
| 2025-12-09 00:00:00+00 | Kairat Almaty | Olympiakos Piraeus | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Bayern München | Sporting CP | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Barcelona | Eintracht Frankfurt | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Inter | Liverpool | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Atalanta | Chelsea | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Union St. Gilloise | Marseille | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Monaco | Galatasaray | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | Tottenham | Slavia Praha | Not Started | UEFA Champions League |
| 2025-12-09 00:00:00+00 | PSV Eindhoven | Atletico Madrid | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Villarreal | FC Copenhagen | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Qarabag | Ajax | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Real Madrid | Manchester City | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Athletic Club | Paris Saint Germain | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Club Brugge KV | Arsenal | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Bayer Leverkusen | Newcastle | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Juventus | Pafos | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Borussia Dortmund | Bodo/Glimt | Not Started | UEFA Champions League |
| 2025-12-10 00:00:00+00 | Benfica | Napoli | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Tottenham | Borussia Dortmund | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Bodo/Glimt | Manchester City | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Real Madrid | Monaco | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Sporting CP | Paris Saint Germain | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | FC Copenhagen | Napoli | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Villarreal | Ajax | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Olympiakos Piraeus | Bayer Leverkusen | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Kairat Almaty | Club Brugge KV | Not Started | UEFA Champions League |
| 2026-01-20 00:00:00+00 | Inter | Arsenal | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Bayern München | Union St. Gilloise | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Qarabag | Eintracht Frankfurt | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Slavia Praha | Barcelona | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Atalanta | Athletic Club | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Juventus | Benfica | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Chelsea | Pafos | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Newcastle | PSV Eindhoven | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Galatasaray | Atletico Madrid | Not Started | UEFA Champions League |
| 2026-01-21 00:00:00+00 | Marseille | Liverpool | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Napoli | Chelsea | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Borussia Dortmund | Inter | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Monaco | Juventus | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Paris Saint Germain | Newcastle | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Eintracht Frankfurt | Tottenham | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Pafos | Slavia Praha | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Atletico Madrid | Bodo/Glimt | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Manchester City | Galatasaray | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | PSV Eindhoven | Bayern München | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Bayer Leverkusen | Villarreal | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Athletic Club | Sporting CP | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Ajax | Olympiakos Piraeus | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Union St. Gilloise | Atalanta | Not Started | UEFA Champions League |
| 2026-01-28 00:00:00+00 | Arsenal | Kairat Almaty | Not Started | UEFA Champions League |