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,7301,7380,7409,7521,7480,3337,1085,9022,7560,4918,6195,7849,8130,7387,4401,7388,7388,7388,1349,7491,8859,7238,8864,7647,7155,7110,8477,8063,8423,7068,8047,7258,8406,7574,7654,8049,8208,9161,9161,8269,9398,9398,9247,9247,9049,2627,2627,2627,2627,2627,2627,533,1768,2778,3881,3784,10032,9229,4460,3511,3511,6740,6740) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC