Changes between Version 5 and Version 6 of ImportantCase1

Timestamp:

01/10/25 15:25:10 (5 days ago)

Author:

222039

Comment:

--

ImportantCase1

@@ -12 +12 @@
 {{{#!sql
 SELECT book.bookid, book.CoverImage, book.Title, book.Genre, book.PublishedYear, author.FirstName, author.LastName
-FROM Book
-INNER JOIN Book_Author ON Book.BookID = Book_Author.BookID
-INNER JOIN Author ON Book_Author.AuthorID = Author.AuthorID
-WHERE book.genre IN ($placeholders) 
-AND book.PublishedYear BETWEEN $query_from AND $query_to;
+                                FROM Book
+                                INNER JOIN Book_Author ON Book.BookID = Book_Author.BookID
+                                INNER JOIN Author ON Book_Author.AuthorID = Author.AuthorID WHERE book.PublishedYear BETWEEN :year_from AND :year_to