select events.event_id, events.start_date_time_local, 
map_event_result_home.hi_level_key AS home
map_event_result_away.hi_level_key AS away
FROM events,
map_event_result,
map_event_result map_event_result_home,
map_event_result map_event_result_away
where events.start_date_time > '20071001' 
and events.start_date_time < '20080404' 
and events.event_id=map_event_result.event_id 
and map_event_result.hi_level='team' 
and map_event_result.hi_level_key LIKE 'l.nhl.com%' 
AND map_event_result_home.event_id = events.event_id
AND map_event_result_home.alignment = 'home'
AND map_event_result.away.event_id = events.event_id
AND map_event_result_away.alignment = 'away'
order by events.start_date_time asc