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,6104,504,6103,7239,6364,3728,1232,7019,6981,3531,7374,5914,1145,7878,7143,7840,7761,7872,7903,7937,4535,7910,7938,3549,867,7358,2389,3419,2182,7770,7771,511,7911,8222,7108,8231,2467,3029,8288,512,7637,8358,5995,4983,7085,4765,4985,8469,7271,7828,3115,3559,8174,2117,8547,8626,507,7928,8705,8704,8706,2473,8706,8480,8304,8706,7125,7775,7077,3725,8683,8087,8818,7751,7972,7973,4406,8213,2989,8908,8909,2989,8776,8836,8910,8947,6821,8816,9029,9009,7599,8943,9009,8944,7595,7881,4969,2029,4983,3169,8141,3532,9198,6138,9202,1230,6138,8812,7589,4701,9216,9278,1770,9307,9331,9330,9349,9334,7998,7999,9277,9422,9479,9546,9212,9558,9612,9613,9646,9649,9383,4985,9727,1768,9736,1766,9770,1890,931,9767,9759,9386,8543,2294,223,9799,9887,9871,4405,7265,8419,9978,9884,9979,10001,10001,10053,10072,10001,4784,10111,9378,9989,8211,10073,10108,10073,10121,8780,10121,10225,10237,10247,10104,7139,9148,9377,10219,8554,10163,10124,10261,9900,9093,10123,7675,9116,9834,10293,10273,409,9257,10492,9423,10531,7777,10543,7766,10543,8914,10543,10209,10129,10127,10467,9136,10818,10724,10976,10649,8842,7634,10412,4128,6130,5893,6157,5070,4659,1381,1402,6103,5542,2137,675,1016,1038,946,5331,1954,6779,2032,2677,1385,5247,6642,1439,6364,4985,3908,6986,7101,5764,7097,4898,5142,7074,7092,7075,1461,1145,6118,7298,7019,4424,7261,7289,7239,7267,7273,7271,7285,5961,501,7158,7272,7208,7036,359,4079,7296,6740,7605,7579,7797,7245,7089,2674,7269,7097,7906,7937,2976,7835,8093,7264,8041,8144,8057,5764,7287,7266,2046,2389,2025,1461,2389,8187,5142,8052,4563,7939,7154,4624,8293,6740,8423,2381,8411,8237,7982,2261,8258,8305,4639,2658,4766,8480,8483,1298,8417,1917,7994,8079,8459,8853,8062,4395,2913,8894,8769,8426,8810,6891,8955,8306,7037,7761,3346,8763,9083,7957,8651,7659,7239,8201,8658,2882,8547,8736,7210,3261,9308,9261,7775,9160,8055,6589,7900,5455,8736,6792,8055,4131,1029,9277,4597,9561,2052,9580,9038,1453,9647,4983,9562,8477,9446,9754,4079,9834,9444,9344,9136,9313,9258,8046,9367,9544,7073,1272,10009,10027,9450,30,10025,9821,9757,665,9316,9594,9954,9530,9257,8711,10056,10123,10261,10274,10125,10297,10144,8472,8019,8052,9575,9161,10512,10535,10353,10364,10182,9999,10356,10451,9370,9091,10541,10570,10694,10693,9158,9509,7261,10767,10039,10145,9259,10582,11134,11230,8062,10476,11116,9594,11337,11371,11671,11542,11651,11654,11225,10399,11476,11538,10401,10030,11767,9999,11805,10814,10582,11802,11794,11890,11754,9259,8740,8424,1755,1272,6831,4985,1402,4424,2946,7937,7592,4144,5484,5872,2652,4510,1209,6119,6139,5188,3595,1738,2467,322,675,186,8358,9030,9130,4834,7635,7839,8851,8845,567,2889,779,810,578,730,4639,645,4405,6809,6845,6104,6805,2615,4659,1603,5484,5904,7146,6979,4774,5116,7303,1764,1460,6687,3492,5276,7144,3797,4854,4316,4964,423,5298,5003,7756,1272,510,4985,6953,1831,7882,7874,4512,2989,5400,470,5763,3358,6559,7981,7988,952,1092,3856,665,2331,7994,2913,3719,7956,3893,8135,5889,3878,4087,7287,4652,1184,3136,5995,7807,5332,7937,6732,7971,549,5965,4616,3824,8483,8484,6560,3169,5252,8257,4784,4830,8514,8573,1872,8471,2024,6192,1349,7985,8305,2989,7251,3580,6255,6829,8713,8306,4535,2467,4834,8780,3131,4131,8514,7903,182,2989,182,2522,5484,6117,7146,7615,7121,8910,9245,1402,9406,9116,7920,9431,9734,6744,9178,9408,8246,8244,8087,8067,9225,7704,6380,6416,6612,9734,9178,9501,9806,4286,4289,4304,4298,4299,4287,4292,4302,4296,4305,7311,7610,4297,7083,7697,7695,7696,7868,7694,2951,3442,11184,11149,11183,11181,11252,11174,5297,11182,10920,1704,11037,11179,11178,11231,11173,11175,11251,11185,11229,11177,11176,11186,338,7937,7664,7111,7643,8144,3954,7994,7125,7658,8560,6691,4570,6103,8547,8281,7834,8358,6264,5320,8480,5997,5763,5567,7849,8683,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,11748,11344,11879,11965,11900,11775,5193,11783,3719,8701,8175,2018,1764,7592,6894,5175,6821,1823,7143,8547,7903,6642,8952,8358,8514,2029,8948,8922,6740,7641,8220,7238,8912,3850,9030,6849,6845,9300,6104,7019,8780,446,2658,9212,8520,9366,4178,9386,4178,7833,9366,186,8306,5995,9159,8816,9936,10056,10126,9079,10240,2925,2467,228,9731,9789,9963,9983,9969,9208,9967,9938,10039,9914,9964,9836,9834,10066,6712,9799,10060,10085,9896,10081,115,9780,8150,7121,8048,9389,7931,9574,6769,8077,9134,9280,8782,7115,9095,10024,9828,9539,8908,9665,10079,9529,9674,8052,9679,9754,9665,10003,7363,10080,9573,1173,9679,10075,104,10084,4535,9888,8126,8125,9665,5059,8946,9189,10084,9554,9381,9465,5917,4985,9900,8620,9926,8135,9731,10003,7131,9967,156,130,1569,7846,4983,10061,7873,7640,8170,2384,8170,10070,8144,10182,10060,9544,9918,40,9918,9404,10267,9126,9959,6891,9125,10240,6891,10190,10021,10493,10121,10183,7921,10541,10547,10566,2644,10464,1563,10261,8759,10669,8608,4761,9460,9558,9824,1740,10293,4140,10672,10832,10226,10820,9759,142,7890,10611,9107,10979,10979,9968,8780,10126,6828,10977,9757,10976,7239,1349,9028,7276,8876,7900,8284,7872,7903,217,5513,4023,1741,156,7088,6664,9304,7815,7086,9308,8877,4796,8880,8477,7088,4535,9299,8889,4019,9561,8369,8460,9581,8772,8071,7674,8636,7285,8286,9910,9922,9959,10022,8184,4765,9817,9819,9818,7097,9526,2032,6769,8106,9125,6872,6889,4563,7144,5052,1142,8430,5053,5056,10116,9666,9212,9991,9800,9377,10008,2122,5420,7037,10081,10754,8092,9554,9036,7830,6805,10312,11021,9758,8915,9492,7987,1369,11129,11103,2288,10412,7285,5688,10847,11334,11338,10022,984,7666,7175,9438,365,380,376,8172,5903,11554,11630,11753,8891,9956,7086,11757,7935,11370,6632,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,10127,10355,5134,1371,6646,4985,2253,2913,10669,5376,8835,11129,10714,665,6785,10910,9790,10517,11199,1561,1318,10665,9872,9799,11272,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,10950,11120,9244,11272,11478,10937,4985,11602,2652,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10909,10339,11900,11363,11302,10380,423,396,11101,10344,11217,10518,9799,10363,8763,10654,10655,10665,10144,10705,10658,9277,7239,10673,10667,7640,10653,10830,10832,9825,8485,10876,2052,10702,7874,11010,9125,10910,10714,9448,9465,7303,9449,1381,10672,10820,7809,578,10514,10724,9758,7812,9009,11201,11198,11200,4898,11236,8135,6769,1029,11199,10905,10362,11339,10741,9244,11378,11359,9558,7994,8734,9046,10737,9308,10184,10541,11480,10021,10234,4395,11373,11487,9759,4800,8388,2453,11554,11473,11604,11456,9963,10177,130,11623,7597,8151,11588,11661,11719,10900,4510,10979,10892,5763,11218,11662,10565,8667,11394,8778,10124,8027,11134,11870,11290,11496,11851,11829,11825,11450,4535,10517,9214,11847,11828,11992,11834,7639,11963,10937,4405,9116,239,2490,8095,6119,10955,2063,10285,10092,10093,4144,8922,8628,10165,10133,10786,10552,10287,9547,10913,10286,8952,130,8995,2469,144,8008,2653,3304,4722,10702,2671,9349,10626,10830,3165,2467,6325,8870,8844,2454,9828,10805,2753,3908,4659,10257,9767,8995,10165,2490,3590,10865,8933,10836,3465,10241,2334,4164,5839,3646,7234,9983,9864,1185,3282,10715,6780,3549,4423,11271,2253,8706,311,11435,10260,11453,7785,7586,11134,11383,2628,8304,11302,3415,10714,9895,1232,665,9538,11669,8955,1052,11609,7824,11382,7777,2658,9014,9354,11272,2934,9281,1593,11620,9473,12011,9647,9078,1755,5623) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC