Changes between Version 4 and Version 5 of ImportantCase1

Timestamp:

01/10/25 14:51:00 (5 days ago)

Author:

222039

Comment:

--

ImportantCase1

@@ -10 +10 @@
 Приказ на сите книги
 [[Image(BT-5.png.png)]]
+{{{#!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;
+
+
+}}}