Query: World Cup 2026 - Standings by Paulo Sousa

Loading chart...

1SELECT DISTINCT st.* EXCLUDE (season_id, team_id, season_year, competition_name)
2FROM @blt.ultimate_soccer_dataset.standings st
3INNER JOIN @blt.ultimate_soccer_dataset.seasons s ON (st.season_id = s.season_id)
4INNER JOIN @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
5WHERE c.slug = 'world-cup' and s.season_label = '2026' and team_name = 'Portugal'
6ORDER BY snapshot_date DESC, st.competition_name, season_year DESC, rank

snapshot_date	team_name	rank	home_wins	home_draws	home_losses	away_wins	away_draws	away_losses	home_goals_for	home_goals_against	away_goals_for	away_goals_against	notes
2026-05-26 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Playoffs
2026-05-18 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Playoffs
2026-05-15 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Promotion - World Cup (Play Offs)
2026-04-23 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Playoffs
2026-04-20 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Playoffs
2026-04-01 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Promotion - World Cup (Play Offs)
2026-01-30 00:00:00+00	Portugal	1	null	null	null	null	null	null	null	null	null	null	Promotion - World Cup (Play Offs)

Query Result