== Приказ на сите книги ==
=== Актери === 
* Најавен корисник

=== Чекор 1 === 
Избор на жанра/и \\
[[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;

}}}


=== Чекор 2 ===
Избор на временски период \\
[[Image(BT-12.png)]]
{{{#!sql
SELECT MIN(PublishedYear) as min_year, MAX(PublishedYear) as max_year FROM Book
}}}

=== Чекор 3 ===
Сортирање на книгите по избор, и селектирање на "Apply Filters" \\
[[Image(BT-13.png)]]


=== Чекор 4 ===
Резултат 
[[Image(BT-14.png)]]