SELECT t.course_id, t.user_id, t.update_time_id, t.training_status, t1.update_time_id, t1.coach_id, t1.project_type, t1.course_date, t1.start_reservation_time, t1.end_reservation_time, t1.max_reservation, t1.current_reservation, t1.course_status, t1.is_break_date FROM course_info t INNER JOIN update_time t1 ON (t1.update_time_id = t.update_time_id) WHERE (t.user_id = ?) ORDER BY CASE WHEN t.training_status = 0 THEN 0 ELSE 1 END, t1.course_date DESC, t1.start_reservation_time DESC


原文地址: https://www.cveoy.top/t/topic/pHY1 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录