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)