WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) GROUP BY t1.event_hours_id ORDER BY FIELD(t3.menu_order,CASE WHEN DATE_FORMAT' at line 14]
SELECT TIME_FORMAT(t1.start, '%H.%i') AS start, TIME_FORMAT(t1.end, '%H.%i') AS end, t1.event_id AS event_id, t1.before_hour_text AS description1, t1.after_hour_text AS description2, t2.post_title, t2.post_name, t3.post_title as weekday FROM ERelezJFevent_hours AS t1 LEFT JOIN ERelezJFposts AS t2 ON t1.event_id=t2.ID LEFT JOIN ERelezJFposts AS t3 ON t1.weekday_id=t3.ID WHERE t2.post_type='events' AND t2.post_status='publish' AND t3.post_type='timetable_weekdays' AND t3.post_status='publish' AND( (t3.menu_order=CASE WHEN DATE_FORMAT(CURDATE(), '%w') = 0 THEN 7 ELSE DATE_FORMAT(CURDATE(), '%w') END AND SUBTIME(t1.start, CURRENT_TIME())>0) OR t3.menu_order IN()) GROUP BY t1.event_hours_id ORDER BY FIELD(t3.menu_order,CASE WHEN DATE_FORMAT(CURDATE(), '%w') = 0 THEN 7 ELSE DATE_FORMAT(CURDATE(), '%w') END,), t1.start, t1.end