SQL subquery

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 awayFROM EVENTS , map_event_result, map_event_result map_event_result_home, map_event_result map_event_result_awayWHERE events.start_date_time >  '20071001'AND events.start_date_time <  '20080404'AND events.event_id = map_event_result.event_idAND 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_idAND map_event_result_home.alignment =  'home'AND map_event_result_away.event_id = events.event_idAND map_event_result_away.alignment =  'away'ORDER BY events.start_date_time ASC LIMIT 0 , 30