Baselight
select matches.*, home_teams.name as home_team, away_teams.name as away_team, *
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)
where matches.match_id = '9fdc13ab-d0b2-53ed-a26a-be578b2b217f'
match_idseason_iddatehome_team_idaway_team_idvenue_idreferee_idstatushome_scoreaway_scorehome_extratime_scoreaway_extratime_scorehome_penalty_scoreaway_penalty_scorehome_halftime_scoreaway_halftime_scorehome_manager_nameaway_manager_namehome_formationaway_formationhome_teamaway_teammatch_id_1season_id_1date_1home_team_id_1away_team_id_1venue_id_1referee_id_1status_1home_score_1away_score_1home_extratime_score_1away_extratime_score_1home_penalty_score_1away_penalty_score_1home_halftime_score_1away_halftime_score_1home_manager_name_1away_manager_name_1home_formation_1away_formation_1team_idnameteam_typecountrystadium_idfounded_yearteam_id_1name_1team_type_1country_1stadium_id_1founded_year_1
9fdc13ab-d0b2-53ed-a26a-be578b2b217f303aa2bc-6fba-5c17-825f-40b2cccd71262025-06-04 00:00:00+00ee9be42a-0a4a-5e0c-8885-c64e414827a3421512b8-7304-5373-ac02-70b4452113b04b4d8f39-1e8e-5d78-8ef1-d0627e4e0ab0nullMatch Finished12nullnullnullnull00J. LöwRoberto Martínez3-4-2-14-3-3GermanyPortugal9fdc13ab-d0b2-53ed-a26a-be578b2b217f303aa2bc-6fba-5c17-825f-40b2cccd71262025-06-04 00:00:00+00ee9be42a-0a4a-5e0c-8885-c64e414827a3421512b8-7304-5373-ac02-70b4452113b04b4d8f39-1e8e-5d78-8ef1-d0627e4e0ab0nullMatch Finished12nullnullnullnull00J. LöwRoberto Martínez3-4-2-14-3-3ee9be42a-0a4a-5e0c-8885-c64e414827a3GermanynationalGermany61bedc4e-1c06-5f83-94b6-a03bd908528d1900421512b8-7304-5373-ac02-70b4452113b0PortugalnationalPortugale68390d8-96e2-57aa-8ec9-9e599c6b01ff1914

Share link

Anyone who has the link will be able to view this.