SELECT e.* FROM tx_odcalendar_event AS e LEFT JOIN tx_odcalendar_event_category_mm AS mn ON e.uid = mn.uid_local LEFT JOIN tx_odcalendar_category AS c ON mn.uid_foreign = c.uid WHERE (e.deleted = 0 AND e.hidden = 0) AND e.pid IN(35,33,32,30,29) AND (e.sys_language_uid = 0) AND (((e.begin_event_date >= AND e.begin_event_date <= )) OR ((e.end_event_date >= AND e.end_event_date <= )) OR ((e.freq != "none" AND (e.until >= || e.until=0) ))) GROUP BY e.uid ORDER BY e.begin_event_date ASC