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,8175,9038,9036,9258,9402,9439,9366,9278,8925,9406,9372,8999,7874,9220,8999,9273,9086,6642,9627,9552,9554,9614,9543,9249,9937,8089,1699,10003,10042,10050,3990,9904,10063,10145,10039,10056,10212,10265,10229,10246,10243,10127,10342,10341,10227,10354,10002,10514,10268,10528,10315,10568,10543,7582,6124,10548,6595,10472,10569,10749,10733,10787,10777,10836,10870,10879,10397,10938,10892,10893,10895,11020,11021,11121,11122,11018,11089,11106,10871,11202,11220,11219,10523,11237,11235,11353,11324,11381,11349,8140,10665,11455,11377,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,9542,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,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,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,8962,665,2998,8999,8182,4901,8306,1245,8141,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9981,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,11304,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,11457,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,8134,8936,8979,9543,10133,10144,10081,10204,9318,7884,9559,6795,4906,1497,9336,9031,9649,8489,10380,10713,5810,10145,10672,10667,10658,892,10056,10836,10893,10870,10550,10775,10861,10738,11021,11051,6104,6809,6845,3162,5996,4049,1453,834,6315,6642,5636,5837,2118,5764,6709,1576,6348,6710,1953,6861,4185,6863,4570,36,6364,6713,4277,6645,2160,3715,5013,6123,1559,4767,4886,739,6981,6842,5997,6994,4131,6740,7238,1127,344,7138,6862,3557,7761,7835,7836,6858,7779,3059,7126,7019,7878,7919,7833,7304,8019,7981,7016,7992,1521,850,7834,7751,8220,3217,8193,3754,7972,7580,2419,6698,6857,7973,6117,6962,8547,4798,8440,4510,252,8355,8353,7541,6984,6127,2023,8356,4617,8807,8827,7970,2183,8306,8305,7860,5739,3823,8955,8997,8543,8910,6968,8681,8933,8355,8698,6174,8948,8353,7974,8356,8817,7032,9258,9222,7928,9223,6412,6967,3595,9009,6175,4806,5602,9223,8222,8793,9195,9925,9290,8290,9888,10039,9926,9835,10212,10229,8169,10127,7833,8435,8441,8290,9017,8628,7910,9072,9073,9073,5207,9090,8780,8780,9215,8615,8615,8991,9389,9389,8706,8706,585,4805,4805,8922,3474,3474,8534,8534,6188,6188,9545,9545,6104,9767,9258,9108,9931,9959,3558,637,9319,9319,10056,10079,8927,4985,4985,9993,9993,10176,10212,311,9464,4639,9838,9838,223,223,7823,7823,107,10523,10548,10548,10608,10608,6642,6642,8547,10702,10626,2989,10667,10667,10836,10814,10814,10938,10512,10738,10738,9757,9757,10972,10976,10976,11027,10977,10977,11121,9555,10228,10228,11089,10904,1461,11219,11172,11172,10039,11272,11272,1439,10748,10748,11310,11310,11324,11130,5321,2160,2160,7583,7583,11455,1381,1381,11353,10937,11496,11604,7904,11554,9777,11609,11690,11741,10397,3885,3760,9321,4862,8247,8730,3327,6845,9363,6971,8901,8520,9402,9552,9951,947,9600,7233,8726,8615,4337,4233,4209,3904,2025,9373,8193,5516,249,9052,4234,1215,10212,9879,10526,9453,8922,1439,6104,10739,10765,162,8995,6809,9614,9234,8888,10127,10870,4665,5013,3989,10549,10634,10636,8834,11141,8010,11020,11028,10964,11122,11220,8681,162,4598,9527,10042,10003,1349,8955,10063,1134,10149,10057,10062,10048,9937,10144,8514,7138,10227,61,9406,4432,9930,8105,9961,5553,10183,9066,10273,7839,3080,10127,10342,4277,10378,7829,10476,9346,10121,4460,9249,10512,10569,9757,10568,10674,10243,10538,10685,10129,608,10653,1253,10514,10783,10745,10359,10065,10743,10244,9935,9372,10893,10880,10303,10878,10895,145,10113,10683,8999,10740,1347,5903,11027,10341,10719,10739,10744,10748,9725,9454,8935,10871,11126,11123,10114,10719,11100,10476,9983,10893,10895,8557,11172,10747,6699,6635,4460,7017,11272,4061,11220,11340,8010,10977,11237,11353,10856,11285,11287,11349,10543,11361,10528,228,9278,10870,3115,11202,10879,10893,11171,11107,10842,11489,11201,8910,9928,11084,11381,11604,11287,9832,9298,11599,11377,7005,9439,11647,7038,11083,3936,3847,11517,11554,8514,10739,10749,7876,8853,11646,11396,11681,8031,11724,10814,9922,11678,10782,9833,11243,9831,10288,10289,10266,5193,8835,11396,11785,7602,3501,8550,361,10233,8548,252,10039,11670,6874,11021,11377,9677,11875,9600,10359,11784,11423,11717,8105,1347,5688,11822,5545,11703,5193,11235,11443,8915,11702,4652,7593,5917,8935,5817,9799,11965,11873,8805,11874,10396,9634,11871,11783,9363,11964,11991,12001,10649,5790,10632,10690,7715,11027,2736,2761,11104,9959,2137,3100,6103,9543,6740,11103,10784,11128,11126,11142,11202,11217,11112,11235,11237,3908,11123,10951,11222,8214,4079,3728,5013,4665,10127,3346,9810,10269,10870,8010,7990,6622,10611,2615,6348,11220,11349,10937,6633,11423,10125,11136,11226,8144,9757,10976,11065,11281,8763,8626,11041,9546,11129,11094,11352,9479,11288,11258,11105,11107,11604,10085,11491,11598,11495,11595,11498,10971,10668,11480,11132,11230,10655,11496,11521,11658,4950,3197,4724,11733,9406,10569,10786,11127,4882,11439,11747,11449,11492,9539,9541,9602,11550,11787,2092,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,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,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,11919,11923,11872,8889,8836,8869,11966,8890,7876,10749) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC