Changes between Version 4 and Version 5 of ImportantCase2

Timestamp:

01/10/25 14:51:54 (10 months ago)

Author:

222039

Comment:

--

ImportantCase2

@@ -6 +6 @@
 Избор на жанра/и \\
 [[Image(BT-11.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;"
+}}}
+{{{#!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.PublishedYear BETWEEN $query_from AND $query_to;
+
+}}}