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,8706,958,7903,4362,5995,5303,6595,9066,6774,4983,8482,6337,9257,8688,8889,6774,1257,7120,9578,4146,8820,7155,7654,7654,7647,7665,2473,6726,7076,1371,7605,3896,7986,9132,8666,3913,587,7126,7953,9340,9116,9900,7913,7572,7589,8290,10095,6152,7761,1439,8193,4290,233,7919,7019,501,6707,2123,6010,8222,4304,1119,5286,6337,1080,4131,1038,8031,1121,6679,8514,1215,4209,735,8089,585,3941,4220,6635,5995,1349,6639,6732,3244,5487,7920,6848,2294,4625,3003,1253,3142,7839,5817,2894,1347,6981,4258,4460,4082,6858,1165,3080,7883,5339,7126,2933,3913,5545,8134,8805,3195,8795,5807,1432,7709,8915,4652,8548,7550,8935,8936,8979,3368,8932,3715,36,8687,2590,1298,6862,7896,739,9000,1572,3396,8905,5739,4648,9200,4337,9196,9081,6595,6740,7238,8220,8904,3115,3559,5331,507,2025,6632,4233,8688,9300,4566,7710,3612,8615,5875,4355,8104,4209,179,4553,5349,9372,9038,7025,5039,321,2419,4128,5236,228,9604,6986,9249,6407,6700,8651,9777,9777,7815,9017,9296,3775,4437,4769,9376,1380,9952,9768,7104,4860,1371,3941,3860,5996,2976,5764,6315,5020,3561,4566,252,793,1402,836,4234,5321,3100,5088,606,5764,4969,5286,5837,6779,3037,1907,1137,1690,4875,6686,8215,7156,1176,7840,5541,1177,1190,2324,4766,4223,2381,2882,3525,5795,5543,7875,1835,3921,6635,4088,6639,8004,1439,1163,5373,7919,9073,9086,3625,8901,252,5142,1521,1137,5131,7858,9243,2657,3715,8793,3493,7016,8902,8888,4056,1177,7582,8629,228,6866,9376,8901,9464,8900,5541,9402,9376,7883,6707,5379,7017,8999,2294,8900,7875,8548,6713,8819,5339,9638,2957,9197,9654,5817,9637,1347,5545,7126,9766,9552,3754,9798,9335,9807,9879,1253,1461,1699,9925,2933,7017,7839,9764,8978,4258,608,9921,7126,8548,9454,4460,9680,6858,9932,8999,10056,9661,9961,10055,9993,10036,9929,10134,9769,9952,10116,5986,4805,4701,2976,9421,9453,2025,9273,9904,10063,4209,10065,10229,10244,8151,9897,10079,10212,10042,10243,10244,9665,10053,10118,773,10245,10211,10149,4652,9541,9347,10258,10227,9045,4337,9249,10307,10377,9831,8805,10342,10355,9476,10245,10062,10246,10266,8934,8915,10523,10524,10473,9833,10548,10397,10568,10523,10528,10127,10627,10416,10348,4665,8010,6248,10246,10628,7718,10350,10569,10734,10879,10735,10899,10341,10798,3413,10870,10300,7614,8795,10737,10938,10375,10814,7615,10894,10711,10608,11020,11021,11023,11018,10972,11042,10913,11089,10878,10765,10893,10911,11121,9930,11122,11126,11123,8948,11100,11142,3003,10749,10783,10784,11171,9072,3288,11220,11219,6117,10530,11234,11230,11237,11235,1134,9634,11199,10910,11287,11288,11285,10719,4028,10798,4665,4209,3134,9922,11349,11361,4103,9928,10990,11353,7261,8408,7150,7713,7900,8577,7297,7275,7597,8170,7653,7298,8092,1569,1885,4019,8144,8772,8279,8456,8282,8206,8456,7733,7734,8071,8648,7641,8089,2989,7920,8358,7019,4652,7761,4639,9245,9557,9444,9329,9401,9443,9399,9400,9446,9447,9445,9398,9367,9448,9917,7661,9918,9926,9889,9759,9919,8048,8041,7261,9930,9929,9921,4798,7068,8071,8439,8368,9461,9931,10244,10227,9817,4178,9543,10476,10149,9961,7086,8837,8793,446,9661,9195,5995,9160,7258,1349,11028,1350,10063,2594,11021,11219,766,1215,6842,1257,2706,2033,2632,9453,2932,501,10375,4234,5148,3989,4796,5070,5799,10878,9648,9634,6117,8543,11838,1917,1461,9993,9661,11324,4254,5743,4598,1311,4854,240,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,3287,8805,7829,8961,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,8442,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,9741,10512,9299,11187,11834,10847,11604,11388,10190,9800,11691,9308,6104,6845,10871,217,10935,11594,7126,7883,3080,4258,6858,5817,1699,5545,7839,608,10568,11495,5339,1347,4460,1253,11041,9325,167,11678,11787,11827,11645,30,145,228,9928,11838,11288,11764,11123,11140,11180,10362,10871,11020,10770,11821,6785,7920,8548,9372,9937,10243,10065,11783,11235,11871,1349,10787,11521,181,167,107,10523,10569,11991,8999,4652,10856,969,2933,11784,10472,2294,11873,11919,9924,8776) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC