SELECT pp.person_id, p.person_key, dn.full_name, ihos.points-ihos.assists AS goals, ihos.assists, ihos.points, pp.regular_position_id, pos.abbreviation
FROM stats s, persons p, display_names dn, ice_hockey_offensive_stats ihos, sub_seasons ss, seasons, positions pos, person_phases pp
WHERE s.stat_repository_type = 'ice_hockey_offensive_stats'
AND s.stat_repository_id = ihos.id
AND s.stat_coverage_type = 'sub_seasons'
AND s.stat_coverage_id = ss.id
AND ss.season_id = seasons.id
AND ss.sub_season_type = 'season-regular'
AND seasons.season_key = '2007'
AND dn.entity_type = 'persons'
AND dn.entity_id = p.id
AND s.stat_holder_id = p.id
AND pp.person_id = p.id
AND pp.regular_position_id = pos.id
ORDER BY dn.full_name