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,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,5543,4670,7810,7718,971,6552,4752,3989,7761,3976,3493,6563,585,6556,4209,6883,6863,6576,4878,6993,7840,2863,8183,7879,7878,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,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,11282,11122,11021,10528,11324,11272,9647,10110,10911,8889,11131,9959,10911,6824,4901,10014,10013,10012,11423,10108,10109,10016,11495,1232,10017,10018,6981,10004,10005,11489,10648,11455,11608,9212,10619,10164,10015,10621,10620,11443,10894,11314,11361,11645,11435,11349,11705,11551,11699,11670,11661,11491,9220,11646,11495,1185,11235,11280,11608,11703,11488,11455,11838,10355,11919,11923,11872,8889,8836,8869,11966,8890,7876,10749,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,6863,5576,6104,6552,6809,3625,4131,4199,6845,1461,2261,6793,4045,6632,4337,3895,6705,3921,3888,1439,4046,4049,4513,5286,3889,3885,947,4652,7646,7354,2776,1145,7665,3892,4432,7251,7761,4983,6595,5732,7671,7671,1126,1559,7261,4566,8089,8417,6986,4061,4128,7759,8031,4432,8450,7273,7833,9746,9747,9622,9621,9619,9620,9132,7920,9133,9910,7920,8193,3904,739,7759,7839,4950,254,4411,4258,4209,5542,4234,6104,5339,5286,1253,501,233,5331,5286,2976,3830,8183,231,6858,2294,338,1461,8183,4355,7304,3080,1347,4460,5545,2933,231,1520,1461,5516,640,254,1119,6632,3080,3613,1681,6248,7126,4796,1119,1762,7883,6245,6256,8548,6248,6255,8502,3976,1699,5543,6249,5732,7839,419,6250,9372,1485,8819,4460,2933,1347,3080,24,30,1298,3368,5817,6862,7147,6691,4701,2590,739,2419,3376,3396,2023,608,7839,5732,640,946,4411,1490,4452,5536,1688,7710,6124,3391,3558,8278,8276,8548,2018,3115,507,3719,3559,8705,8174,8704,3941,4455,4088,4875,7751,7972,7973,3921,4613,8224,9122,4950,8681,8698,8817,9041,9372,7903,9300,7833,7920,7875,9038,4566,9744,1783,7261,7665,9875,9876,9877,9878,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,9300,9072,9376,9637,7928,8706,8991,8819,8846,4596,8846,4596,6632,6632,8304,8890,9543,6707,4240,9761,7821,9223,7656,2576,3534,8062,8220,6740,7879,8319,8317,2627,6223,6139,6964,3159,4784,3564,4778,8615,3904,5331,4209,9378,4337,9418,1210,1073,2894,9533,2736,4791,8890,6703,9464,7759,4625,1190,9873,6848,10046,1176,4596,3976,5025,4100,10523,7222,9270,10086,10094,10056,5170,3904,6354,3073,2698,3070,10134,9603,9475,2271,986,3351,3429,5631,10132,10133,2707,1159,4901,5837,10210,10018,780,743,772,4406,10277,5131,4653,10285,10286,802,1441,1160,1110,10205,3825,10287,7758,7858,6852,7865,9353,7864,1915,2654,1277,9607,732,10207,10241,10242,10104,7856,7855,7221,3731,10130,10209,10148,10344,10345,2912,10374,8946,10376,8919,10358,6902,141,10243,10373,6163,10065,9406,9511,3731,8910,8095,10416,10543,10400,9910,8813,10399,8812,9252,10401,10479,6901,9929,10120,9937,10362,10476,10530,9769,10046,10660,10661,10662,10112,9386,10633,9748,10119,10118,9761,4240,802,5321,2657,10709,10708,8687,10710,9253,9251,1835,1190,1177,9466,8387,1176,7554,7754,7755,7756,7927,8509,10528,10062,9770,9222,9253,9251,10787,10857,10523,10395,10836,10814,10870,10396,10358,10569,9614,10632,10244,10634,10917,10918,10568,10635,10584,10583,10636,7029,10919,2912,7674,141,3351,7856,9512,9531,9532,2658,9551,9566,9569,9570,4199,9568,11028,8615,9528,4624,4730,8902,446,10212,10895,8888,8278,8276,8275,10657,10913,10911,9981,8799,9987,10141,7221,10205,10207,9277,3428,7239,10066,10165,10236,9402,8031,1253,5545,10413,4969,9454,11027,10414,7636,8095,608,1368,10549,10837,848,10512,7580,4766,9391,9982,4233,9571,8252,3100,10649,11112,6163,11141,8842,5013,5154,10113,10114,8629,8837,3029,228,10063,11142,9904,10967,11102,9543,217,10087,11219,11126,10938,11217,4337,6863,11202,11122,11220,11100,11084,11123,28,11106,11268,9638,7550,10397,11180,4984,645,1917,9950,11219,10784,661,10127,744,6731,57,467,1092,89,4785,4536,2873,11374,2871,6730,4329,6692,4882,6776,3100,2317,6185,11330,5131,4406,11228,4046,4048,4045,10377,8147,7057,7003,6736,4049,4050,6741,2033,8517,6705,4136,7016,9251,8812,8813,9252,9464,11302,11235,2639) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC