SELECT tcourse_idtuser_idtupdate_time_idtproject_type_by_usertcourse_date_by_usertstart_reservation_time_by_usertend_reservation_time_by_userttraining_statustsubmit_timet1update_time_idt1coach_idt1pro

SELECT t.course_id, t.user_id, t.update_time_id, t.project_type_by_user, t.course_date_by_user, t.start_reservation_time_by_user, t.end_reservation_time_by_user, t.training_status, t.submit_time, 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, t1.is_update FROM course_info t INNER JOIN update_time t1 ON (t1.update_time_id = t.update_time_id) WHERE (t.user_id = 350000000) ORDER BY CASE WHEN t.training_status = 0 THEN 0 ELSE 1 END ASC, t1.course_date DESC, t1.start_reservation_time DESC, t.submit_time DES