|
|
|
|
|
FFIM Books -
View the books in the category:
| Title |
Author |
Rating |
No Results: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and cat.book_id = FFIM_book.id
group by FFIM_book.id order by title' at line 5Error getting book data
SELECT distinct title, sum(FBR.rating) as total, count(FBR.book_id) as count, author, date_added, submitter_name, submitter_email, FBK.id as id, FBC.name as category, FBC.id as category_id from FFIM_book FBK,
FFIM_book_category FBC,
FFIM_book_x_book_category BXC
LEFT JOIN FFIM_book_rating FBR ON
BXC.book_id = FBR.book_id
WHERE FBR.book_id is NULL AND
FBC.id = BXC.book_category_id and FBK.id = BXC.book_id
AND BXC.book_id = FBR.book_id
AND BXC.book_category_id =
group by BXC.book_id | |
