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,6011,8261,1516,1272,7831,8187,2986,7994,6113,8110,7970,8091,7124,6955,8608,8547,2520,1586,8358,7607,7239,6119,8305,6979,8306,2246,7982,6821,1050,2766,6328,1051,7599,7615,1557,2946,8541,8483,7093,8742,8914,1049,6905,2507,6740,9053,8554,8933,9107,6788,9030,458,5052,4154,6261,4639,7238,8220,9300,8761,5063,8651,1556,5165,9259,7619,9381,8628,9336,7910,9327,8290,9465,9387,8208,9450,9538,9547,2253,9331,9647,9652,8063,9754,8542,206,8403,9788,311,9789,2913,7900,220,4395,9257,8763,9889,9046,9933,9967,186,8434,9963,10026,130,7671,2487,104,609,10163,10050,8439,236,10182,10073,10177,10225,10144,10257,9824,10261,10234,10360,10519,10518,10541,10547,10714,10615,10820,10876,10910,5790,10712,10979,8206,176,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,11089,5688,11103,9093,10000,6769,8222,7579,7837,4079,1210,7834,4639,7835,7836,6740,7143,4087,8358,7238,223,8220,8517,3282,7989,8306,8547,8480,2117,8610,435,8610,3014,8629,8214,5143,4218,7923,3850,8842,1207,8905,8912,6599,1127,8916,9000,665,1345,8578,8780,9046,9130,9195,9017,1461,9072,3062,4625,8933,8706,5154,9200,9242,984,9254,7907,5536,9300,3761,8495,9322,9332,9333,9334,5732,9308,9289,9291,8103,9337,1057,179,8150,3595,2135,9456,3059,9419,9290,8688,7803,9196,9347,9541,8543,8306,9552,8306,9353,8306,7581,8306,6117,9607,9603,9604,7143,6857,1890,9641,9634,9654,9643,9668,9642,9644,2360,9377,4240,9680,107,9616,9761,9234,8805,9648,4219,9676,9769,9766,9780,9800,7856,772,9798,3844,4800,3303,2299,9116,2294,5515,5765,3590,2398,9258,1416,9913,9916,9938,9942,8913,9635,5841,780,9961,3844,9543,9945,129,9471,3159,3788,444,5692,1834,8870,8844,972,10047,10049,6848,1727,1822,360,10056,734,7615,10104,6681,5812,7016,2674,6827,1181,10128,10129,9086,3181,10141,10149,3437,10119,10120,8925,10048,10061,967,9472,1522,9963,1906,10093,220,4126,9116,5821,2743,1485,1000,152,10229,10242,10241,180,148,958,1461,2135,2192,3585,2299,10131,10282,10284,8884,4947,7019,10273,2687,2642,1826,3561,10283,9936,2421,4656,4566,4972,2571,10342,10338,10246,9348,115,10300,10380,10373,10209,10358,9050,4527,10374,10373,10440,5743,6171,10469,4168,10467,10476,10416,10479,9374,9638,10042,6267,9220,3608,5877,3035,4986,8851,9454,8837,10523,10114,10244,10527,10247,5551,8902,10394,8800,10549,10541,10537,10548,10543,322,10514,8514,1954,10021,4385,9193,1057,7550,6691,162,8901,10671,10649,9904,4767,4696,10665,7017,7582,10674,10569,5729,10745,1954,10747,10787,10798,4023,10780,10814,10737,10663,3715,10784,10836,10688,4082,10135,10782,6713,252,10878,10699,10870,5373,10935,10894,7016,10910,10892,10934,1350,4136,1521,10938,10918,10966,1955,5142,10895,10893,10656,7140,10397,606,10782,8900,10988,5379,6828,2192,10233,7614,1532,9834,6643,10708,11028,10709,7064,10710,9081,10285,3054,7021,2270,2271,1131,10221,2672,10344,3825,10345,10513,11084,10320,123,11090,10661,10662,11105,10398,11104,7143,10990,6838,239,10899,10778,9872,10673,11104,2642,7016,7710,9254,3391,9768,9254,9270,1277,7016,955,6861,1441,2654,1055,2707,1160,1159,30,243) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC