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,6595,5331,3904,6599,6141,4598,6190,3598,2830,5564,2145,1500,1645,7374,6190,9159,8022,9460,5454,6774,6843,1366,1782,7898,7391,714,714,714,6579,6579,6579,6579,4979,4979,6602,6602,6602,6602,6602,6561,9830,7102,916,7899,358,3647,176,7908,915,1385,1385,5947,8220,7974,8110,7904,7605,2063,3250,7032,6175,800,5915,6832,8393,6210,8055,8055,7833,5848,6588,7903,1662,7023,2269,5688,8942,6618,2182,8948,5421,1385,8554,6785,6785,126,8940,7585,7175,8319,8243,8312,8335,8248,8245,6270) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC