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,3850,6158,4121,666,4338,2594,1070,6350,4185,1520,5995,233,6010,5252,1380,2263,4218,5915,461,2261,4597,714,6001,6130,6589,6155,220,1038,7160,3860,2992,8836,7238,8933,6740,7238,8154,8154,4121,8922,6876,10086,10086,8628,6740,5175) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC