Query Error SELECT id, name, record_id, public_rate_weekday, special_rate_weekday, public_rate_weekend, special_rate_weekend, image, time_start, time_end, hole, c.ordering AS course_ordering, c.id AS course_id FROM fs_courses_teetime INNER JOIN fs_courses_en c ON c.id = record_id WHERE is_hotdeal = 1 AND ('2026-06-25' BETWEEN date_start AND date_end) AND (day LIKE '%5%') AND c.published = 1 ORDER BY record_id, special_rate_weekday, special_rate_weekend ASC LIMIT 10