select persons.person_key, display_names.full_name
from person_phases
     inner join persons
             on persons.id = person_phases.person_id
     inner join teams
             on teams.id = person_phases.membership_id and
                person_phases.membership_type = 'teams'
     inner join display_names
             on display_names.entity_type = 'persons' and
                display_names.entity_id = persons.id
     inner join publishers
             on publishers.id = teams.publisher_id and
                publishers.publisher_key = 'sportsnetwork.com'
where teams.team_key = 'l.nfl.com-t.30'
order by display_names.last_name, display_names.first_name