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,9999,10000,10001,10154,10155,10155,10155,10155,10155,10155,4847,2594,10451,10174,10173,10649,11267,10175,10041,10031,9963,10021,10060,9963,4405,9968,308,10072,9988,9978,10061,9941,10056,10125,10121,10125,10183,10182,10163,9652,6348,9917,9917,10220,9967,9918,8214,10228,10261,10111,9307,10269,9967,10129,10267,10412,10113,10362,9701,10114,10312,10512,10313,6889,9835,10550,10538,10527,10547,8290,10553,10240,10003,10541,10182,10674,10667,10649,10650,10566,10723,9448,10656,10741,10668,9979,10814,7774,10820,10480,10785,8515,9790,10935,10910,10786,10934,10938,10679,10905,6809,10976,10679,10905,10976,10679,11026,11027,9465,10303,11026,10673,9872,11090,7602,8268,8571,11094,11089,5688,11103,9093,10000,6769,11129,11127,10518,11121,11090,7970,10048,9336,11120,10229,11136,11200,11199,11222,11217,2913,10979,4254,10314,10778,11271,11169,11266,11280,10184,11315,3647,11201,11338,11352,11324,11382,6646,11351,8517,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,5992,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11220,11272,11315,11339,3493,11372,11382,11361,11121,6177,3921,3585,3100,3941,6599,1248,3479,4046,3172,1038,5148,5215,4740,1038,5764,455,4045,2421,4739,734,1152,5081,4088,4455,5837,2387,4539,6703,1163,2381,2632,5331,4861,4385,4045,1954,4839,5543,4670,7810,7718,7857,971,6552,4752,3989,7761,3976,3493,6563,585,6556,4209,6883,6863,6576,4878,6993,7840,2863,8183,7879,7878,7857,4773,176,4220,1917,7903,7834,2674,748,752,836,3454,967,1826,231,8793,3715,4082,1521,3370,7614,8888,8925,8901,5373,7615,4258,5339,5545,5817,7126,5247,3368,7920,2294,6861,1253,6858,7883,3080,2933,8615,8548,8999,5837,7857,608,7839,1347,9372,1699,9614,9195,6809,6845,6104,9200,9541,9366,9300,7619,9925,9321,7619,7875,9897,8890,9463,9937,9777,9349,4460,9888,7928,4223,9921,9478,10065,8846,10039,8948,107,9615,9993,9464,9661,9808,8819,3549,9258,10090,10087,9527,10243,10089,10088,10342,3346,9052,10260,10480,9374,9453,10548,10212,10265,10259,10127,9798,9929,10568,9347,10476,9634,9930,6117,7581,10784,3080,6857,8543,9648,10878,5339,10086,9961,10915,10523,10375,10626,6632,10149,10937,6793,145,10738,11020,4765,9045,7919,10210,10913,9387,11142,9389,11022,11235,10804,10938,11219,1232,11195,2615,9198,11280,11234,11220,11281,10227,11122,11021,10528,11324,11272,9457,7278,8052,9577,180,10349) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC