this

MySQL returned error




Error Description :
Error No : 1064
Description : 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 ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1

SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,895,8715,1666,8849,6264,9132,9797,8439,7297,9552,9741,9739,9740,9738,10869,7987,7715,8071,7714,8530,4399,10379,4769,2843,8034,7674,9118,6895,4406,2179,10269,10056,8477,9813,7280) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC