Changes between Version 2 and Version 3 of UseCase0007
- Timestamp:
- 09/02/26 20:34:22 (4 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase0007
v2 v3 18 18 ee.ee_start_time, 19 19 ee.ee_end_time 20 FROM applications a20 FROM holds_event_function hef 21 21 JOIN event_functions ef 22 ON ef.ee_id = a.ee_id 23 AND ef.ef_no = a.ef_no 22 ON ef.ee_id = hef.ee_id 23 AND ef.ef_no = hef.ef_no 24 JOIN event_function_types eft 25 ON eft.eft_id = ef.eft_id 24 26 JOIN event_editions ee 25 ON ee.ee_id = a.ee_id27 ON ee.ee_id = hef.ee_id 26 28 JOIN event_types et 27 29 ON et.et_id = ee.et_id 28 WHERE a.student_index = 230014 29 AND a.application_type = 'event_function' 30 AND a.application_status = 'accepted' 31 AND ef.ef_name LIKE 'Main Organiser%' 30 WHERE hef.student_index = 230014 31 AND eft.eft_name = 'Main Organiser' 32 32 ORDER BY ee.ee_start_time DESC; 33 33 }}} … … 43 43 s.first_name, 44 44 s.last_name, 45 ef .ef_name,45 eft.eft_name, 46 46 a.application_type, 47 47 a.application_status, … … 53 53 ON ef.ee_id = a.ee_id 54 54 AND ef.ef_no = a.ef_no 55 LEFT JOIN event_function_types eft 56 ON eft.eft_id = ef.eft_id 55 57 WHERE a.ee_id = 8 56 ORDER BY a.application_type, ef .ef_name, a.application_status, s.last_name, s.first_name;58 ORDER BY a.application_type, eft.eft_name, a.application_status, s.last_name, s.first_name; 57 59 }}} 58 60 … … 77 79 s.first_name, 78 80 s.last_name, 79 ef .ef_name,81 eft.eft_name, 80 82 a.application_type, 81 83 a.application_status … … 86 88 ON ef.ee_id = a.ee_id 87 89 AND ef.ef_no = a.ef_no 90 LEFT JOIN event_function_types eft 91 ON eft.eft_id = ef.eft_id 88 92 WHERE a.ee_id = 8 89 ORDER BY a.application_type, ef .ef_name, a.application_status, s.last_name, s.first_name;93 ORDER BY a.application_type, eft.eft_name, a.application_status, s.last_name, s.first_name; 90 94 }}} 91 95 … … 95 99 SELECT 96 100 ef.ef_no, 97 ef .ef_name,101 eft.eft_name, 98 102 s.student_index, 99 103 s.first_name, 100 104 s.last_name 101 105 FROM event_functions ef 102 LEFT JOIN applications a 103 ON a.ee_id = ef.ee_id104 AND a.ef_no = ef.ef_no 105 AND a.application_type = 'event_function'106 AND a.application_status = 'accepted'106 JOIN event_function_types eft 107 ON eft.eft_id = ef.eft_id 108 LEFT JOIN holds_event_function hef 109 ON hef.ee_id = ef.ee_id 110 AND hef.ef_no = ef.ef_no 107 111 LEFT JOIN students s 108 ON s.student_index = a.student_index112 ON s.student_index = hef.student_index 109 113 WHERE ef.ee_id = 8 110 114 ORDER BY ef.ef_no;
