SELECT dn.first_name, dn.last_name, p.person_key, bos.points_scored_total
FROM basketball_offensive_stats bos
JOIN stats s ON s.stat_repository_id = bos.id
JOIN persons p ON s.stat_holder_id = p.id
JOIN display_names dn ON dn.entity_id = p.id
JOIN person_phases pp ON pp.person_id = p.id
JOIN teams t ON t.id = pp.membership_id
JOIN sub_seasons subs ON subs.id = s.stat_coverage_id
WHERE 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';