SELECT r_class,r_time,r_date,r_doctor,r_status,r_id,r_memo FROM tb_reservation WHERE r_date >= '2069-10-27' AND r_date < '2069-11-03' AND r_class = 232 ORDER BY r_class ASC,r_date ASC,r_id ASC