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 
LIMIT 0 , 30