Books - By Category

Book ListChartsCategoriesGolfRecipesHome

Click on a book title to read the full review and discussion.
Click on an author to see summary of all their books reviewed.
Click column headings to sort this list.
* Denotes Booker Prize winner.
** Denotes shortlisted for Booker Prize.

Problem!

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Query: select book_cat from dim_book_categories where book_cat_ID =

You are looking at books in category:

Problem!

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by date, title, last_name, first_name, score order by date_finished desc' at line 1

Query: select books.book_id as book_id, DATE_FORMAT(date_finished, '%d %b %y') as date, title, last_name, first_name, score, count(comment) as comment_count, booker_prize.Booker_Winner as bp_winner from books left join books_user_comments on books.book_id = books_user_comments.book_id left join booker_prize on books.title=booker_prize.Booker_Title AND books.last_name=booker_prize.Booker_LastName left join fact_book_categories fbc on books.book_id = fbc.book_ID left join dim_book_categories dbc on fbc.cat_ID=dbc.book_cat_ID WHERE fbc.cat_ID = group by date, title, last_name, first_name, score order by date_finished desc