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,446,6642,6167,1947,6774,4986,6599,4395,6354,3070,4662,1095,2951,4512,4706,3428,1084,6578,4218,6740,511,512,510,3828,512,511,321,7546,6596,1368,7580,4131,5331,6635,6595,6315,6010,6595,1765,5837,5286,5321,3921,6639,3941,4088,4539,3896,4950,4463,4773,4596,2025,1371,6863,958,6703,4670,4739,4740,1461,4878,3625,4875,2337,4136,7016,5373,252,3885,6792,7363,1521,5081,5142,3542,947,3890,4131,7550,5995,1626,2997,1368,7953,7580,9300,2989,9273,5039,4730,4901,8257,5210,9466,9637,9376,9198,7783,9161,1185,7572,8816,9275,8055,7675,2615,6715,6723,7589,9134,2753,8305,7840,7879,7878,6712,9321,5576,7879,2869,6122,9039,9449,8850,9116,2164,223,8826,9386,8815,9467,8358,8305,8822,8683,7636,4639,1368,9258,812,6663,8955,9308,9879,9606,8494,9884,6113,9772,9825,9969,4144,4663,9730,9963,9612,2253,9883,9900,7900,9967,142,10085,10073,9952,10087,10039,10121,10047,9990,5692,9942,5743,10048,10145,10188,8780,780,7865,2912,772,4109,4982,8845,7758,7864,169,9130,2170,8842,3610,10233,7775,10237,10247,10126,308,10241,10242,10225,5765,5623,2170,6681,10234,10124,10072,10319,3647,10364,10182,9834,8836,10294,3465,10480,10303,10505,10518,10293,10538,9214,10549,10177,10566,10436,10535,969,10656,10714,10611,10751,10711,10665,10697,10777,10672,9919,10541,10780,10712,10715,10663,10871,10866,10892,10699,10904,10905,10868,10786,9257,10912,10467,10830,3159,10935,10988,10934,8913,9987,8912,10141,8842,6599,5707,10832,10781,10893,10658,11010,10398,10820,10807,10023,8076,8077,10588,9225,9247,142,10708,10710,10709,10287,9825,7793,11484,11195,11383,11435,217,7874,10679,10687,2164,11371,8076,7123,8475,11744,11436,11705,8556,11927,11331,11848,7546,8731,5572,1770,1770,1770,1770,7631,7551,8192,8192,5454,675,6880,675,1368,7580,1411,810,1349,6200,8935,6198,4282,9197,4291,4304,4297,4287,7697,7694,7695,7868,6212,6526,7693,6521,6520,4652,4386,6654,7182,8896,7189,7185,7178,7179,6652,7184,7181,7183,8897,7188,6653,7176,6214,7180,6497,6499,6216,6501,6498,6222,6218,6215,6220,6221,6212,6223,6511,6531,7845,7844,6510,6509,6508,6513,6514,6515,1165,6507,7843,1266,1685,5297,1349,9248,1767,1768,1765,1769,7170,7172,7174,7173,4473,7165,7164,7167,7187,6512,3073,6354,3071,6689,3070,6688,7753,7752,8088,8627,9037,8946,7186,7166,9383,9867,8943,8944,8945,7881,7599,9679,1368,7636,4121,5064,5053,1765,1770,9911,9912,7972,7751,7973,8276,8275,8278,8888,8728,9343,9722,9721,9720,9723,8816,8946,9669,3359,2951,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4291,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,9632,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,8323,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,7568,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,10443,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,10332,10327,6197,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,9430,10200,10560,7696,4293,4305,10322,9114,9426,9424,9409,4298,9112,9113,8883,2824,10136,9894,9633,4304,10215,8662,9908,4294,6200,2825,10218,2823,8727,1765,9120,8326,8627,1771,9626,4296,1768,7174,9037,6689,1767,2808,1766,510,1771,9473,8944,9669,9407,7752,7677,8627,9920,8432,9474,10154,10725,10642,8971,10139,9665,9475,10155,9601,10298,10729,9493,10238,10522,9383,10637,9867,8586,10152,5576,10877,7636,10232,4386,1368,9687,10828,7580,9031,10641,11048,11008,6800,11046,7870,11088,11019,10329,10864,9854,9911,10645,11007,10565,9912,10463,10647,11047,10866,10923,10646,10154,4464,11014,9046,7019,7165,10155,7166,4486,8780,9215,4470,7761,10157,7677,10156,7551,8222,2818,10519,11051,8793,4855,2816,11109,11183,11184,11022,11192,10706,11193,9168,10053,11191,2780,11241,11231,11242,9690,11149,2791,10544,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,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,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,10176,10098,3073,10175,3071,8583,9880,4714,6689,9679,3070,1266,8727,2506,272,6198,5810,9824,7881,7752,10053,9665,8899,8897,10067,8896,6200,9867,9031,8489,6215,8668,1766,4842,4286,6218,4297,6216,2794,2791,6497,2789,3071,6880,675,2786,2785,2787,3465,2783,2781,2779,2780,2782,6443,7868,4304,4293,10258,2778,979,7311,10238,9473,10251,9669,4224,2951,1970,6679,9477,10188,3385,6002,8233,9073,9243,9478,545,8714,9383,9476,529,40,10055,3358,10294,9483,5207,1690,7185,7184,8815,4223,9632,3525,1369,138,7178,7179,7632,7189,4386,7176,9921,9637,1137,7187,6198,6362,1325,10258,10398,6382,10608,3875,7837,7834,9376,10607,7835,4931,3254,10552,7836,9297,10467,10536,1557,10568,10232,4,510,9474,7771,7770,6688,511,512,7637,9626,867,9067,9625,9670,9671,10612,8729,9475,8881,8161,10364,9624,10626,8882,8878,10642,10647,10639,10643,9880,9625,8880,10644,7569,7762,4804,7567,7570,7764,10298,9493,7698,10641,8016,10640,9906,9907,9970,10043,10253,10255,10256,10637,10646,10254,10752,10531,7300,10645,3165,10521,10753,10548,2261,6855,222,10522,1520,1917,3059,1461,3595,3493,145,8306,4178,5995,10212,11105,6710,7019,6876,7761,11032,8222,8793,11031,9195,9552,9925,10229,11106,9661,10397,10315,8965,9675,9655,3874,4923,4146,3409,7172,3511,10749,10938,9993,10544,11033,7753,8627,11109,8088,8946,8945,10927,8944,8668,6263,10975,11121,10641,3236,9933,7810,8110,10239,10821,10822,10931,10930,10840,10639,10637,5066,8943,10748,10926,10928,10797,4923,11255,11252,11254,11251,7592,7554,7754,7755,7756,7927,10564,8509,11246,6740,40,6683,145,9635,5,173,8978,10207,11217,11240,9363,6639,4023,6732,2843,5431,8220,9300,7238,7912,11325,7849,10056,10836,1368,28,6598,10637,7580,1769,1766,1768,145,8175,1765,10893,1983,7304,11101,11395,9072,11397,3327,11398,11401,9543,11382,30,152,801,9,11383,1230,9352,8389,11381,11328,11431,11421,11171,10057,7356,6773,11396,6792,10687,4510,4752,1973,10788,11442,5363,122,10827,6359,1411,9466,11479,11473,11476,11359,10829,11478,11480,11468,10278,3014,6727,5513,11177,11477,6692,11416,10520,9149,8154,8002,11067,11071,9322,11517,11181,11550,8904,9677,11342,9378,10350,8688,11598,11552,4329,11175,947,4103,6740,7910,3327,1368,7636,8618,8682,9084,7172,9407,10238,11019,9920,10565,9084,7631,11218,7184,11016,5635,4386,7179,7189,6652,7178,7182,11240,510,8897,7770,7180,7772,7771,511,512,8946,6654,11013,6688,9473,11014,7181,7183,11354,7176,6653,7188,11419,11421,11422,7187,11418,11420,9407,9084,8682,10565,10238,9920,11146,11147,11148,11015,11082,11392,9437,11019,7998,4386,9129,11218,9671,9670,9669,8946,7186,11464,11493,11462,11463,8172,10750,11431,8007,6596,9233,10433,11017,8971,11430,11414,11429,11321,6836,11498,8610,11446,5988,11521,10472,6521,11181,11487,11495,11427,1347,5339,5545,9084,9920,8682,11362,8681,11109,9958,8698,11468,9492,6216,10864,11269,11649,11349,11664,6497,11377,11378,11678,11069,8154,10042,9638,9220,10941,11493,11647,11349,11724,10895,8900,9638,9220,10569,10787,10856,10042,9904,9086,252,5373,11126,11678,6713,11237,51,4082,7550,8837,5193,3018,10367,8780,4401,10824,24,9896,11355,1770,7184,8306,6713,7185,11016,11647,11463,11464,7176,11488,11664,5255,11876,6800,28,10942,9492,11093,524,543,553,539,535,529,532,554,7124,7078,9933,11592,7107,3888,11624,10482,9439,9290,11349,10354,9601,9334,8902,11724,11981,9888,8542,8434,10442,6740,11121,11690,9300,10056,8541,8922,1190,6836,9233,11622,8582,6240,11442,8819,2294,156,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10647,11922,3874,11432,6354,7636,9418,1368,7580,6603,6616) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC