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,6795,463,6315,5995,5020,409,5222,6571,1416,3303,6569,219,6678,1577,6141,231,7209,4156,2605,3872,7081,7261,7290,321,4259,7255,7278,3888,1770,3172,1185,5208,8296,8222,7238,8514,3897,8757,1537,8469,7752,2006,7115,8651,7775,8709,7714,1569,7168,7166,389,7547,1993,8109,9614,8053,9134,9831,7642,435,8048,698,5454,5582,4362,2986,7304,5371,3428,6740,7238,8220,6190,1095,5134,5134,5995,5995,2029,2029,6891,7592,609,9049,6549,4395,3549,8839,7794,1516,7840) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC