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,11101,10953,10960,11257,11117,11117,7258,7249,8626,8734,9247,9326,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,11222,11010,11025,11121,6740,10844,7592,11025,2253,11215,10940,10305,4424,9765,10212,8257,4512,6953,10649,10669,9976,10731,10228,8628,10907,8628,10907,10956,8115,3949,11215,3336,3334,1371,11195,9386,2913,6836,10884,10495,11310,9889,11305,11413,10495,3712,7304,9030,4302,6742,7473,1988,6242,4317,3074,6174,6814,7964,8686,9351,3337,3823,1462,8732,2417,1250,7473,10932,10916,9601,6953,8780,4923,3327,4769,10874,10731,11379,10579,6715,5647,9685,9693,840,2913,9692,9713,11298,11661,2989,8648,1116,4801,6855,9787,4788,10505,11400,4510,11101,4716,8139,10940,8628,9865,10379,9865,10717,10940,11399,10687,10987,6561,1145,11410,11074,10339,1993,11101,3863,10687,9865,11497,9762,653,10604,4805,8292,7042,11085,778,10336,3511,11568,10107,2145,5769,317,11519,11307,11380,11908,11900,10649,4985,9830,11266,5769,9340,11401,11401,8825,11399,9985,10107,4405,11101,8714,10687,11101,5567,10669) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC