SELECT
	persons.id, teams.id, 
	display_names.full_name, display_names2.full_name,
	sum(baseball_offensive_stats.home_runs) as hrs,
	sum(baseball_offensive_stats2.home_runs) as team_hrs,
	year(events.start_date_time) as season
FROM
stats, 
stats stats2, 
persons, 
teams, 
baseball_offensive_stats, 
baseball_offensive_stats baseball_offensive_stats2, 
display_names, 
display_names display_names2, 
events,
events events2,
person_phases
WHERE 
stats.stat_repository_type = 'baseball_offensive_stats'
AND stats2.stat_repository_type = 'baseball_offensive_stats'
AND stats.stat_repository_id = baseball_offensive_stats.id
AND stats2.stat_repository_id = baseball_offensive_stats2.id
AND stats.stat_holder_id = persons.id
AND stats2.stat_holder_id = teams.id
AND persons.id = display_names.entity_id
AND teams.id = display_names2.entity_id
and display_names.entity_type = 'persons'
and display_names2.entity_type = 'teams'
AND person_phases.person_id=persons.id
AND person_phases.membership_type='teams'
AND teams.id=person_phases.membership_id
AND events.id = stats.stat_coverage_id
AND events2.id = stats.stat_coverage_id
group by display_names.full_name, year(events.start_date_time)