Changes between Version 2 and Version 3 of UseCase0001
- Timestamp:
- 09/15/26 01:50:40 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase0001
v2 v3 21 21 JOIN members m 22 22 ON m.student_index = s.student_index 23 LEFT JOIN has_stage hs24 ON hs.student_index = s.student_index25 AND hs.valid_to IS NULL23 LEFT JOIN membership_stage_records msr 24 ON msr.student_index = s.student_index 25 AND msr.valid_to IS NULL 26 26 LEFT JOIN membership_stages ms 27 ON ms.ms_id = hs.ms_id27 ON ms.ms_id = msr.ms_id 28 28 WHERE lower(s.first_name) LIKE lower('%Dario%') 29 29 OR lower(s.last_name) LIKE lower('%Dario%') … … 46 46 s.phone_number, 47 47 ms.ms_name AS current_membership_stage, 48 hs.valid_from AS current_stage_valid_from,48 msr.valid_from AS current_stage_valid_from, 49 49 ym.mentor_index, 50 50 mentor.first_name AS mentor_first_name, … … 55 55 JOIN members m 56 56 ON m.student_index = s.student_index 57 LEFT JOIN has_stage hs58 ON hs.student_index = s.student_index59 AND hs.valid_to IS NULL57 LEFT JOIN membership_stage_records msr 58 ON msr.student_index = s.student_index 59 AND msr.valid_to IS NULL 60 60 LEFT JOIN membership_stages ms 61 ON ms.ms_id = hs.ms_id61 ON ms.ms_id = msr.ms_id 62 62 LEFT JOIN young_members ym 63 63 ON ym.student_index = s.student_index … … 77 77 SELECT 78 78 ms.ms_name, 79 hs.valid_from,80 hs.valid_to81 FROM has_stage hs79 msr.valid_from, 80 msr.valid_to 81 FROM membership_stage_records msr 82 82 JOIN membership_stages ms 83 ON ms.ms_id = hs.ms_id84 WHERE hs.student_index = 23002485 ORDER BY hs.valid_from;83 ON ms.ms_id = msr.ms_id 84 WHERE msr.student_index = 230024 85 ORDER BY msr.valid_from; 86 86 }}} 87 87
