select c.country, c.name as competition, s.season_label, teams.name as team, m_stats.type as stat_type, m_stats.value as stat_value, m.referee_name, m.match_id, m.date
from @blt.ultimate_soccer_dataset.matches m
     INNER JOIN @blt.ultimate_soccer_dataset.match_stats m_stats ON (m.match_id = m_stats.match_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams teams ON (m_stats.team_id = teams.team_id)
     INNER JOIN @blt.ultimate_soccer_dataset.seasons s ON (m.season_id = s.season_id)
     INNER JOIN @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
where c.name = 'Premier League' 
order by m.date, m.match_id, stat_type, team
limit 100