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,7646,7904,7674,3169,8063,7252,7992,5719,3754,7265,8213,4079,2052,4152,8208,8290,8206,8434,7903,6178,4395,7272,7278,8229,7976,8206,8393,7097,1142,3702,2521,8220,7272,8918,3595,1038,4766,748,4635,5247,5247,5764,2160,958,3037,5215,6809,6845,4355,7138,5629,3558,1402,7143,3549,4765,5334,6124,6986,6780,5542,4566,5455,7759,7907,8031,7597,6891,8024,4185,8019,8151,8305,7910,4985,1121,8261,7760,8547,8550,8306,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,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,10355,6152,7761,1439,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,9542,1380,9542,9952,9768,7104,7101,7275,7241,7280,7290,7276,1917,7153,5516,6710,1738,4061,4411,7830,1439,176,7992,3493,3613,7869,1681,2669,2123,7019,7938,1487,6633,1145,6632,7580,6023,2677,7760,388,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,3189,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7642,7105,3026,8281,840,8358,6732,8547,7246,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,9461,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,11416,4882,6776,7920,3904,739,7759,7839,4950,254,4411,4258,4209,5542,4234,6104,5339,5286,1253,7857,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,6710,2033,4223,4860,501,2932,1461,766,4798,5070,585,1690,4796,1038,3989,3037,2706,3904,6863,6693,3595,4061,5148,4969,2632,2261,4234,5995,1325,3830,1215,5799,1257,3241,4209,4656,5179,3080,5286,2657,739,36,6779,6679,4886,3964,504,446,228,5543,2976,3493,5331,2294,7143,608,6858,6595,1699,5795,7126,4258,1137,5817,1253,7709,5545,4460,997,5339,4178,3059,3080,4635,2933,1347,6981,5207,5142,3775,7019,6632,5193,3525,6986,1917,4566,748,1347,3100,233,7582,6842,3542,7761,5373,2337,7883,2894,6010,6713,4131,7920,1521,7759,7839,1369,215,2658,969,2025,802,7238,6740,5236,4987,8548,5996,6713,7138,7760,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,11041,1265,10667,11900,11951,11937,11921,10438,11324,11736,11872,964,1762,9868,11991,10872,11594,12012,5380,7840,8581,1770,1536,8278,1765,3933,1771,1767,7592,2998,1511,3712,8255,1485,924,3744,1769,5656,1768,1766,1762,5551,5020,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,7869,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,8269,7660,8388,8441,8489,8526,6971,8611,7071,7258,8687,3368,8739,8734,8699,2590,2419,7585,7585,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,7388,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,1779,7654,7155,7083,7083,8793,8544,6381,7307,7124,323,7270,6004,6740,7238,8220,2041,6715,7976,7076,8738,6569,182,8541,8922,6843,3647,2331,6700,659,9338,9612,186,3368,6861,2005,7896,6583,7761,8222,9268,4385,1152,5516,254,8686,254,8686,8544,752,9257,8151,9552,9354,9629,3304,1257,6632,1257,6632,4234,9422,9235,7828,5236,6712,9406,6445,9296,6139,9386,9543,9612,9646,252,10128,5070,9453,4861,10173,5784,9951,5784,9951,8222,7125,7675,9619,9965,9964,10024,9619,739,3850,5331,1433,3368,320,5764,3715,3542,6792,1559,6117,5373,6635,4131,5331,6559,6782,4185,2294,5349,5542,5142,3625,5717,3368,6713,1038,1299,512,2160,5215,511,1521,6315,5020,6639,1347,3037,6693,6595,6548,3080,5339,2933,6858,922,608,6154,24,6700,5247,223,5885,6367,3026,3904,5875,36,5837,6584,30,239,6674,748,1536,1576,736,585,104,510,6713,6560,1253,6792,504,754,3474,6862,3863,2387,768,1067,1113,1347,1872,6793,1523,7138,4028,1526,1569,2381,4194,321,2660,2419,7005,2639,1055,5331,4126,511,4061,6188,2299,1647,5764,3413,1727,5614,5817,4362,6845,955,7358,6809,6104,4923,1568,741,3419,1823,3561,3933,2976,3701,6699,3936,967,5236,2590,7839,4553,7012,1134,7025,7883,784,1920,7759,3117,7780,3134,7840,3129,7876,7760,7712,7859,7879,7821,7858,7855,6981,6315,4624,7865,7856,7719,5543,6734,2882,6697,7920,7896,6679,4258,4460,6986,5545,4566,7126,252,1268,4969,7354,2244,7919,8089,3100,4128,8000,7156,4901,6684,4082,6337,6314,4730,1073,5047,1439,1127,1298,7550,8543,6131,4886,7840,6740,7238,8220,8215,8225,7827,5739,7559,6117,6365,7981,7138,8900,1311,6945,3195,6478,4432,8888,8902,6136,2018,360,1698,8901,3542,7605,8146,1521,156,9036,969,9200,9279,36,9116,739,2387,6792,6713,9329,9244,9372,9322,9374,2944,3542,9273,7580,7138,1349,9258,1215,8306,6337,1521,6942,8925,7038,8681,9018,9051,8698,9050,8687,9109,4023,1432,8031,1257,9406,7005,6663,6664,4652,8514,8795,8805,9363,9454,8910,9402,9391,9333,9421,9335,8978,9346,9366,9308,9197,8934,9248,7839,2514,8817,5180,9041,2841,2246,4679,4504,609,7354,8254,1005,9249,1586,8935,9471,3549,5334,8794,7910,8547,8955,4765,6780,4194,5215,1576,2117,8915,752,2387,8019,254,5516,4538,6684,6642,5121,9459,2709,4405,2669,428,9600,2123,5602,2118,1762,9604,9606,5379,1681,1572,1498,6874,9627,5640,3613,4099,6867,4056,3457,3964,228,8629,1080,9038,3023,9638,2743,162,9455,1121,9634,7581,1119,9335,5046,9653,9657,6663,9635,9383,9677,9665,9345,2925,8296,2594,3368,6740,7304,3957,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,7640,2554,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,6980,8927,9648,10734,10892,11703,8620,4056,11670,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,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,10355,11020,11028,10964,11122,11220,8681,4005,178,5362,179,971,9661,2329,1906,752,2709,1163,9897,4710,5460,2889,5460,4005,9875,8923,9878,9956,840,9877,9873,9876,9874,7362,41,9552,8829,9925,5551,7905,3402,7634,3059,1520,8617,8851,4109,4986,567,10116,9808,10048,10245,10283,9420,9831,10128,9780,9668,9913,10273,9602,10127,10284,9456,10265,10173,8948,7833,7903,7143,10233,10246,8953,10302,10531,3457,5516,3523,6867,6874,10554,11690,11121,11644,8034,8925,8901,8947,1349,7920,7037,8837,156,6266,4805,9033,1738,2467,9038,6986,8089,8884,320,36,1349,6569,7647,2989,3719,9196,665,4395,9249,3142,446,6266,1439,3523,6863,5331,9195,8915,7019,9464,1215,5732,9376,36,8089,9553,9556,9557,254,9526,6845,1461,8934,4947,4769,9637,9372,24,104,9639,5142,206,9648,9654,9641,9750,7388,458,947,9824,9779,9930,9543,9926,9363,162,30,145,739,9937,9340,9972,9965,9221,6986,10062,4156,10057,10063,1325,608,7602,9553,9638,10149,93,9764,10042,6798,9635,2976,3878,1559,8358,2594,220,10212,6632,6104,6261,446,1299,7138,7036,10258,10244,36,228,6117,6163,61,10267,501,93,10300,9335,9754,6858,5148,9811,10182,9638,4056,1347,9764,10243,9220,10227,9052,5267,10476,10350,7017,10341,10416,9476,41,10396,10315,10541,10530,10543,9807,10568,308,8999,10127,9249,10548,10657,8615,10548,10608,10523,10622,10569,10652,5795,9107,10528,10663,9937,5513,739,61,10780,10719,10375,1127,1257,10784,10787,10749,10870,228,10893,9798,10894,10669,6696,10895,10672,10878,10737,10870,9353,10798,10883,11021,2706,11028,10856,10964,11041,10879,10784,10871,10748,11027,10373,9406,1047,252,10683,10764,10512,11123,11106,11126,6113,11018,3532,10667,11122,11197,11235,11135,11219,11234,11129,11180,11199,11281,11220,11041,11287,11142,11171,11200,11340,11105,11324,10744,11330,10754,11104,11361,11201,11377,10747,10566,11353,11227,11107,9935,10783,9910,11234,11349,11288,11455,11127,11492,11495,11266,10910,7810,5997,11478,11442,11494,11488,585,11395,115,11489,6696,180,9248,8934,11593,10747,10892,11134,156,3523,11599,6696,739,11324,11647,11491,11396,11646,10246,7761,11670,11644,11550,11689,11594,10065,162,11491,9402,11658,11455,10548,11309,11594,11180,4258,10798,11646,11613,8031,8869,11235,10568,9749,1298,4969,11480,10917,10126,11477,11783,11787,7995,57,10531,11479,2590,10919,11606,10002,11644,5046,4325,7017,11827,10917,11834,228,11871,11838,11764,11819,11835,11849,11872,3904,1253,10065,28,30,11495,10892,10314,9648,11847,11871,11869,11900,11904,11921,11848,7839,11342,1176,10091,11235,1699,9769,11725,11498,7883,2933,11964,7126,779,11020,2615,11495,10358,11873,11784,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,10355,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,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,10726,10728,10555,8244,11042,2709,9416,8917,11082,11085,2743,3613,8260,11050,10522,6600,1762,1681,11050,8336,9792,10606,9231,5656,10970,10607,8319,3613,8874,7370,6485,5516,8599,11050,10324,8875,10799,11055,8598,11139,8699,9112,11009,10963,11008,11137,11149,11048,11047,11151,2826,6442,11054,11157,2827,2825,11057,8242,11160,11159,9409,11138,11161,6489,2815,2823,9184,9410,11158,2822,2821,2824,11156,11240,2816,2817,2820,2818,9407,10565,11218,2806,2808,2807,2812) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC