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,6870,7775,8220,6740,9043,9044,9043,9266,9303,9300,10468,10707,7639,8831,10086,6875,10056,8142,1990,1990,4659,4659,4659,6740,1645,9785,9649,9976,10836,9975,6740,10809,10482,867,10477,9021,7380,7380,9865,7400,3334,8793,8816,8816,1371,1371,1371,1371,10290,3913,7898,435,5269,10826,11024,10649,11053,11101,5770,10831,10203,1250,10670,11380,2658,10687,10940,8139,9866,11412,8302,9729) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC