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,5995,1038,5996,2160,6103,5321,233,4355,228,6315,5837,4056,5421,2194,1998,6361,1453,6633,358,6100,5885,1591,6709,6769,6312,3921,5914,1402,6718,6588,4088,5081,5371,6151,1327,458,6616,3549,6103,464,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,1767,1769,1768,1766,5386,524,5995,4316,2244,6006,4411,6100,5419,2218,3038,1145,1345,6023,4798,6953,4226,4535,4048,4405,4801,5484,7022,2117,3913,4950,240,6768,6633,358,6891,7143,5915,6102,7146,7144,7238,6947,7130,5912,5421,4154,6364,6863,5331,6831,4983,698,4765,6712,7127,1184,7239,3647,7773,7781,7751,6348,3346,3728,7592,6687,7554,7754,7755,7756,7068,7761,7840,7879,8222,7878,7910,5997,7363,7288,2389,2869,1738,5515,5371,4527,1461,2869,1890,7159,2187,4061,1351,834,217,6858,7046,5179,1462,5882,5995,6364,6940,4637,6845,6693,6365,7138,6396,7131,5046,7359,7005,7049,6110,6727,6766,7022,3989,7032,3100,3561,1131,179,6740,6986,7238,455,1350,4385,7210,7144,7023,7156,7141,7058,7206,3936,6710,1461,7050,6809,6104,3165,5491,2652,3523,1823,7126,6856,1742,6969,7741,7745,7742,3043,566,1461,421,4600,7304,1248,7130,1370,3549,1398,4395,6588,7829,7751,446,6642,6167,1947,6774,4986,6599,848,4395,6354,3070,4662,1095,2951,4512,4706,1084,6578,4218,6740,501,3241,3644,5516,228,1762,3744,4325,5460,4770,3046,640,4801,1490,3201,5732,4452,2023,2117,4411,946,3491,1558,5602,3550,3698,3754,4535,1029,2052,637,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,11197,11200,11034,11063,10787,10820,4901,10914,1576,11201,11347,11324,1886,958,11130,11402,11278,11488,11376,11117,10039,10494,10885,11115,10687,2266,11495,11449,11497,11455,4154,4520,11782,8937,8299,8144,8516,8468,1385,11272,11234,10720,9277,11776,11187,11843,11840,7804,7893,11704,10269,9007,9757,10869,10854,7069,3913,3609,5927,7304,7278,6004,7215,6578,1988,7143,3604,8220,7840,7833,5995,7112,3609,8082,8358,2473,2473,2473,8514,8947,1755,6175,6700,1462,3169,958,3646,6967,6383,2253,6366,2913,7149,5421,6642,5376,6644,2261,5046,311,7872,6548,7605,1998,6130,6104,5484,6845,6809,4412,7022,2490,8178,665,7994,7982,1116,6364,6979,7981,2761,4079,4405,8220,840,7992,7834,7812,7879,7836,7878,3131,6521,7663,7764,7762,5091,7568,3520,7570,7246,7569,1656,8071,1770,7151,6531,7650,7649,4301,4293,4289,4299,4286,4305,4287,4294,4292,7643,4302,7963,4297,4298,2766,800,5024,7079,1085,6103,6780,972,8300,5371,8531,1086,7599,3519,979,7906,8587,7568,6532,4804,8836,8814,1667,6306,8520,9038,8816,6618,9030,8092,801,7808,6189,3216,435,344,5572,6645,228,1145,5839,6540,6122,6544,6172,6257,1425,1210,5777,3825,501,2594,5459,3302,6350,933,4079,463,5305,7850,6544,6971,501,766,4860,7240,4796,3217,4861,3264,2164,8390,2632,8306,3989,6167,4454,8781,6740,319,5995,915,7761,4535,7239,1371,7761,4079,7602,6642,4178,6006,1379,1379,4178,4535,446,7238,6740,7878,8220,8250,8485,8358,8436,8434,7918,6769,8356,698,5454,5582,4362,7004,2986,7304,5371,6740,7238,8220,6190,1095,5134,5134,5995,5995,2029,2029,6891,7592,609,9049,6549,4395,7250,666,7095,7273,7081,7271,4405,8220,2915,2915,2915,2915,2915,2915,7660,7175,8483,8547,8151,8019,7774,4983,6891,6715,2849,6691,3549,2467,7773,1016,470,421,4535,1593,4423,3797,3728,6131,8810,754,3728,6618,2830,6733,8773,6832,6536,8887,6536,8887,1511,2989,4898,7982,1765,1771,5331,6780,28,566,4769,6621,7112,4234,993,5947,8213,8213,1461,1461,7840,1350,1350,9367,9367,4178,7903,1953,4983,7162,4079,6365,2117,3863,4769,6003,7605,7879,7840,6367,7878,7994,8358,6264,4395,4424,4535,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,367,2117,8877,6493,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,7239,7809,1385,7828,7583,156,4682,6136,9061,1324,2117,8220,6642,8206,4801,6348,8361,8680,8688,9007,8762,7928,9030,9134,9142,8081,8547,8763,576,4405,9049,2913,311,2657,3303,2657,3303,6131,6131,9987,10164,4535,1095,7773,4395,5996,4395,2932,4209,4079,8902,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,5419,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,5799,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,11028,10020,9780,10569,7614,7615,7550,6713,8837,4082,7017,8888,11237,9454,8925,11488,2706,10856,11349,5373,252,3542,1521,9220,10375,11593,9904,5739,9374,9615,4455,4739,10857,4455,4739,10857,1490,640,4411,2023,9987,779,11644,10798,10300,8049,7906,10342,10530,11595,11678,11594,8548,9850,9348,6557,6961,739,11492,1127,10131,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,1052,450,8648,5821,4178,9418,9771,9277,4901,7989,9676,207,28,57,173,923,956,8763,7773,9378,947,1207,10814,1095,2913,1370,10454,10229,233,1520,3059,10278,9661,9993,130,9207,11516,11324,11679,10938,11219,11455,4395,11669,1198,1210,1234,958,2736,2451,2995,1425,3595,311,466,5602,3646,9546,4778,10548,7777,10823,11228,11621,566,11352,11812,272,9554,421,10091,3875,5454,8668,11361,5193,11785,435,6326,8967,11468,11620,450,2989,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,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,10741,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,7998,1016,9029,1385,1385,3728,7607,6170,217,8435,8626,2262,8761,1381,7884,9481,6103,134,3908,9649,9736,9757,9389,7175,8891,8658,7262,9387,10538,10767,8517,10584,9387,10583,10769,10738,9594,10412,11332,11045,8864,11096,8712,9247,8284,11632,8430,11686,10582,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,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,7857,7003,6736,4049,4050,6741,2033,8517,6705,4136,7016,9251,8812,8813,9252,9464,11302,11235,2639,8358,223,7374,9125,5484,8780,6891,3949,8255,6642,9340,6367,4801,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,2932,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,10741,5484,10747,6953,11342,5995,3327,10212,11172,7032,9903,6197,9924,9469,9792,3893,3894,5770,5770,5567,3881,1526,3890,7986,8358,8325,11009,275,11201,8358,11151,11152,11153,11154,11091,8324,11078,8312,11156,10800,8596,11155,11160,11046,4395,9593,10725,10729,8874,8699,8310,4395,10324,10323,10332,11050,541,10326,10325,3883,8244,11161,8330,8337,8248,8318,8326,8272,10828,11394,4614,8824,3883,3888,6872,5066,10892,3895,3890,3891,3888,3896,3889,11589,1770,1765,3887,6493,3897,8274,8271,4936,3883,3327,10279,8358,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,6961,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,11112,9403,9234,4224,9709,1327,11063,11130,10789,7280,8395,7944,9509,9205,8577,10077,8770,9134,8384,8395,9563,8644,8407,8408,8406,8404,10510,10675,8783,8082,7933,7674,8394,7281,8423,8771,11125,8737,9793,11370,11511,10869,11332,11124,11508,8580,9539,8212,9529,7280,10887,9817,7285,9578,7660,9134,11553,10768,11131,11331,10906,11671,10767,9795,7088,7086,8423,11758,11693,7715,9540,11692,10869,8832,11188,10272,11096,11795,8709,8741,9816,11634,8740,11402,9259,11472,8763,4395,11797,11839,8763,11781,11514,11957,9558,11832,458,11889) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC