Improving recurring events SQL

events.sql

SELECT eventdatetime.*
FROM eventdatetime
JOIN calendar_has_event ON  calendar_has_event.event_id = eventdatetime.event_id AND calendar_has_event.calendar_id=1
LEFT JOIN recurringdate ON eventdatetime.event_id = recurringdate.event_id
WHERE 
 (calendar_has_event.status ='posted' OR calendar_has_event.status ='archived')
 AND (eventdatetime.starttime LIKE '2009-11-28 %'
    AND (eventdatetime.recurringtype = 'none' OR eventdatetime.recurringtype = '')
    OR ( recurringdate.recurringdate = '2009-11-28' AND recurringdate.unlinked = FALSE)
    )
ORDER BY eventdatetime.starttime ASC