Unnamed

SELECT dn.first_name, dn.last_name, p.person_key, bos.points_scored_totalFROM basketball_offensive_stats bosJOIN stats s ON s.stat_repository_id = bos.idJOIN persons p ON s.stat_holder_id = p.idJOIN display_names dn ON dn.entity_id = p.idJOIN person_phases pp ON pp.person_id = p.idJOIN teams t ON t.id = pp.membership_idJOIN sub_seasons subs ON subs.id = s.stat_coverage_idWHERE t.team_key = 'l.nba.com-t.27'AND s.stat_repository_type = 'basketball_offensive_stats'AND s.context = 'season-regular'AND s.stat_holder_type = 'persons'AND subs.sub_season_key = '2007_season_regular';