Changes between Version 15 and Version 16 of WikiStart/AdvancedReports

Timestamp:

01/29/24 17:36:57 (8 months ago)

Author:

121232

Comment:

--

WikiStart/AdvancedReports

@@ -357 +357 @@
 DECLARE correct_student_id INT;
 SET correct_student_id = 11111;
+DECLARE c_subject VARCHAR(255);
+SET c_subject = 'Bazi na podatoci';
 
 WITH SubjectBooks AS (
     SELECT 
         rb.book_id,
-        rb.book_title,
+        sbb.book_title,
+        sbb.book_edition,
         ba.author_id,
         a.author_name
@@ -367 +370 @@
         recommended_book AS rb
     JOIN 
+        subject_at_term AS sat ON 
+            rb.term_subject_id = sat.term_subject_id
+            AND rb.term_type = sat.term_type
+            AND rb.starting_year = sat.starting_year
+            AND rb.finishing_year = sat.finishing_year
+            AND rb.student_id = sat.student_id
+    JOIN
+        subject_book AS sbb ON rb.book_id = sbb.book_id
+    JOIN 
         book_author AS ba ON rb.book_id = ba.book_id
+    JOIN 
+        author AS a ON ba.author_id = a.author_id
     WHERE 
-        rb.subject_name = 'Bazi na podatoci'
+        sat.subject_name = c_subject
         AND rb.student_id = correct_student_id
 )
@@ -376 +390 @@
     sb.book_id,
     sb.book_title,
+    sb.book_edition,
     sb.author_id,
     sb.author_name