SELECT * FROM participants_events pe  JOIN events ON events.id = pe.event_id  WHERE events.start_date_time > '2008-04-24 06:00:00'  
AND events.start_date_time < '2008-04-25 06:00:00'  
AND events.event_key LIKE '%l.mlb.com-2008%'
ORDER BY events.start_date_time ASC