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,3702,4450,3581,240,5895,2749,6394,5887,1270,5437,6648,2998,1462,587,6690,6900,6779,6979,2389,6900,7139,6981,7142,7127,7141,5996,1537,7148,7268,7084,7124,2776,4637,455,6267,3608,6437,317,7268,6969,2389,4460,538,8744,8354,4294,8585,9030,9042,3287,8314,7985,665,2522,8206,7639,9029,8947,2522,4259,2467,1591,6788,7605,9342,9061,3878,8689,9674,9547,9320,6103,9757,609,10008,9959,9933,6781,4598,10061,10170,10211,6579,10655,1345,10537,10702,10718,8394,10356) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC