SELECT record.rid, student_list.class, student_list.name, student_list.class_no, record.date, record.room, record.teacher, record.item, record.remarks, record.status, record.odate, record.sid, record.subject FROM `student_list` INNER JOIN `record` ON student_list.sid = record.sid WHERE record.assigned = '1' AND record.date = '2026-11-02' ORDER BY record.teacher, student_list.class, student_list.class_no