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,7258,7249,8626,8734,9247,923,6981,8214,7873,9275,7981,9304,6955,5903,812,311,261,4944,9404,7065,9423,9329,7994,6364,208,9381,2976,6192,206,9013,5011,2507,5885,8151,3195,9421,7719,2882,9334,6838,7839,9243,4985,9260,9612,9069,8957,9198,9200,8187,308,9327,7893,9202,9213,9538,9202,9601,9883,6113,9544,7175,7892,7874,1537,10190,7970,5917,9390,4412,9449,9759,9080,1097,8554,6139,9283,9646,8551,10085,10124,10123,10126,10177,10183,8098,9009,10294,10302,10493,10261,9,8956,7907,7861,7299,10490,10501,4694,10612,10541,9406,8231,8963,10543,10531,8514,4795,10021,9664,665,2168,10816,10818,10819,10847,8144,9819,9919,10814,9343,10978,10844,10954,6891,10741,11064,10976,11216,11222,11010,11025,9280,8830,9382,5903,8027,6200,9633,6198,6199,272,6197,11252,11251,11186,11177,11176,11175,1770,1765,1768,1769,1767,1766,11229,10176,11231,11179,11178,7569,7570,7762,7568,7567,7764,4300,4297,4287,4289,4294,4301,11430,11429,4293,11728,7845,7844,3073,3070,6354,6688,11836,6689,11792,8946,3071,7752,8088,8627,7753,9037,6689,3071,8946) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC