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,3863,5742,1973,5717,2145,5733,6593,6814,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,6484,9866,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,261,314,3074,3702,5996,7915,7722,7938,1811,1831,567,8250,7992,1783,8316,3883,8411,8732,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,2635,6386,6646,3327,3890,5435,5435,5435,382,382,388,388,3337,3337,3337,3337,1558,6388,6386,7702,380,6854,4614,8884,8788,8817,6386,8580,9547,4769,924,5380,9667,3327,5435,5419,5322,4639,3358,3385,1250,10649,10826,2164,1308,1308,3327,3327,3327,3327,3327,9021,7380,7380,10478,9865,7400,2261,8586,10821,8341,10638,9517,10797,10827,9920,10645,510,7178,10467,10820,3023,10796,10176,7179,9534,10795,10640,10257,675,10321,11019,10970,10647,10642,10977,10646,2451,10637,1210,9418,9907,10643,4791,2677,947,3803,10552,2736,3392,5459,10938,1533,1425,7772,4645,7770,956,7771,1741,1370,511,512,173,7637,4535,11137,10278,9493,11043,5251,11121,2995,4029,11138,4779,4762,28,3564,5431,1198,4731,11149,11218,11183,11184,11181,11037,11182,11185,11219,9880,7019,57,7238,6740,11240,11241,11321,11320,10822,11242,10742,11324,10840,10579,6354,3070,3073,3071,6689,4146,11387,11239,2506,7752,11115,8088,11455,7019,7761,8222,8793,8088,7636,8627,1368,11493,9037,5053,8943,1762,8793,9993,8816,8946,5576,10337,11677,11644,3875,3336,1371,11195,11216,9386,2913,6836,10884,10495,11310,9889,11305,11413,10495,3712,11025,4406,11025,4406,9862,11701,4639,4639,1770,7491,7486,7486,7486,7486,7486,7486,7486,7546,8863,3327) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC