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,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,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,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,11282,10184,11315,3647,11201,11338,11352,11324,11382,6646,11351,8517,3574,11436,11435,11447,11424,11417,7828,11447,11480,11496,7009,11494,11359,11477,11494,11488,8884,10873,8281,2063,9950,11112,11554,9950,11603,5688,11112,11554,11603,5688,11195,11608,11680,11679,11682,11717,9989,10294,10338,11736,11446,10875,11719,11800,11850,11851,11825,11855,11478,3913,11895,11879,11344,2615,11900,11904,11923,11902,11290,11905,236,10910,11010,8280,8299,7988,11829,11664,11978,12001,11860,12002,11980,11603,12016,12014,11371,12025,8712,9257,9758,9614,9674,4800,8240,9888,9889,2032,9870,9959,9132,8081,9556,10003,9933,8460,10050,10125,8914,10175,8302,8278,8276,10234,10230,10267,9538,10179,9325,10269,9205,10261,10315,9133,8275,10472,10499,9813,10538,10624,8199,10625,10021,10673,10513,10672,9645,11717,12020,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,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,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,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,11748,11344,11879,11965,11900,11775,5193,2749,2783,2799,5454,7816,8714,2913,8485,2253,5564,6890,9103,2490,6622,2946,8689,9390,6001,9391,5839,7872,3074,314,6831,4800,6174,7206,3358,9258,391,452,10454,5827,10337,10761,10649,5839,4923,9031,10226,11010,5484,10747,6953,11342,5995,3327,3428,10212,11172,6845,4639,8828,1016,4659,9933,8828,1016,2117,5056,4659,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,11064,10976,11216,11222,11010,11025,7971,9132,8393,1766,1769,1768,1767,1765,6740,446,1345,9569,9622,9158,7659,9621,8477,9622,9660,9563,9745,8769,8399,7869,8288,4512,6642,7241,7272,7286,9813,8475,8049,9562,9767,9770,9247,9888,10040,10272,8059,6324,9093,7774,8955,7989,9771,2342,9609,2967,10630,10689,8151,9319,10696,9647,10451,10656,7289,10441,8202,7671,8358,10679,11441,11225,10692,11331,11533,8050,9748,10274,9773,10273,10629,10869,7962,3823,8087,7081,10518,9799,10363,8763,10654,10655,10665,10144,10705,10658,9277,7239,10673,10667,7640,10653,10830,10832,9825,8485,10876,2052,10702,7874,11010,9125,10910,10714,9448,9465,7303,9449,1381,10672,10820,7809,578,10514,10724,9758,7812,9009,11201,11198,11200,4898,11236,8135,6769,1029,11199,10905,10362,11339,9244,11378,11359,9558,7994,8734,9046,10737,9308,10184,10541,11480,10021,10234,4395,11373,11487,9759,4800,8388,2453,11554,11473,11604,11456,9963,10177,130,11623,7597,8151,11588,11661,11719,10900,4510,10979,10892,5763,11218,11662,8169,10565,8667,11394,8778,10124,8027,11134,11870,11290,11496,11851,11829,11825,11450,4535,10517,9214,11847,11828,11992,11834,7639,11963,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,11380,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10863,7095,10733,7092,10914,10362,10782,10737,11513,10400,3115,3719,9293,6631,7894,11515,10039,11443,6779,10587,9189,11528,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,11380,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,10906,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027,10245,8951,10221,1116,10085,10350,9096,10267,10219,10042,9033,9220,10246,8022,148,9758,10127,2337,9086,3625,10464,9934,10523,10548,9136,9543,9283,9200,10568,10569,10244,9283,5373,9904,675,9212,9377,10787,1626,10842,5895,9258,10892,10663,4199,10895,4046,4355,6734,10899,8610,10749,10938,9763,11020,11018,11021,11018,9548,11084,11106,9763,7655,11028,10870,8282,36,11126,8370,9053,1253,2294,11196,11172,11171,11108,11237,11235,11237,11288,11285,11349,961,9928,8799,11396,3244,11423,4537,30,11281,5795,11397,10879,11100,11377,11488,11517,11455,11457,11142,10784,7581,11489,11491,11521,11613,4258,3964,11379,10002,11681,11689,11644,11670,11816,9325,11838,11870,11783,11785,11871,11901,9657,11921,11873,11872,8829,11982,11990,12010,12013,12024,1767,1771,1767,9931,10711,9327,10780,10569,6181,5188,11324,10609,10820,10617,8520,5576,11396,11457,9737,11849,11774,11342,11765,11266,10692,9307,10267,7239,10738,11972,10212,2331,1245,4964,6221,4178,8324,6740,7238,6270,1557,1380,8220,8247,5763,7300,217,6508,8345,8490,6512,6510,6103,6199,6533,2467,6373,6768,8244,2989,7923,1303,6831,2374,735,9001,8151,6880,9243,6855,7594,510,9505,8869,9921,1052,9450,5839,9900,10228,4405,452,4800,10305,8135,2164,1557,2164,9931,11134,8435,8257,10086,8922,11352,9871,8262,11437,5997,1049,11101,4362,8377,11519,4720,6806,11670,1803,1831,3824,1016,9963,11090,11169,10780,11201,11120,10754,10986,11201,11134,11201,10363,9883,11413,11359,11280,11372,11446,11417,11450,11436,9546,10663,11477,11662,11456,11655,11661,11477,11773,11198,11850,11835,11834,11860,11842) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC