SELECT t.team_key, SUM( 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 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 s.stat_repository_type = 'basketball_offensive_stats'
AND s.stat_holder_type = 'persons'
AND subs.sub_season_key = '2007_season_regular'
AND t.team_key LIKE 'l.nba%'
GROUP BY t.team_key