SELECT st.id,d.division_name, c.conference_name, t.name FROM Divisions AS d JOIN Conferences AS c ON d.id=c.division_id JOIN SeasonTeams AS st ON c.id=st.conference_id JOIN Teams AS t ON st.team_id = t.id WHERE d.season_id = ORDER BY division_lvl, conference_name, t.name