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,7004,231,7209,4156,2605,3872,7081,7261,7290,321,4259,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,7290,7646,7099,7099,7099,7099,8236,8236,7150,8034,8961,7715,7715,8365,8450,7650,7671,8460,7155,7151,1663,7075,7261,7266,7647,6569,6550,7106,7932,7105,8406,7674,8065,8055,7070,7654,7122,8201) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC