thisMySQL 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,6691,5484,2447,5965,5314,6210,964,1051,1050,1049,3863,2830,587,856,2893,4598,2520,1052,4599,4602,4600,3864,4603,3440,5208,1981,4154,4068,5098,4181,2467,2989,5351,4076,5952,5351,1056,6907,2393,5951,5959,5927,1010,961,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,5923,6561,6832,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,1308,6193,7374,7759,582,1461,7760,7776,7872,582,431,7899,6312,7790,7889,7908,8031,7871,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,7953,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,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,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,8169,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,6139,2882,5997,6155,1108,314,5908,6102,5256,2113,3037,4730,4766,6104,5995,2324,5247,5088,6829,931,4412,1825,5883,2156,6633,1052,5962,6825,1038,6006,3358,6364,7878,4555,7276,2845,6741,8095,8064,7262,8022,4130,2594,8078,1010,8403,7719,4770,2182,8141,8516,8306,1645,4728,4254,1257,4767,4233,8578,1559,5373,8722,8552,8289,8639,2989,8,3989,6154,7374,8841,8095,934,8587,8915,3262,5763,3297,8144,4337,8615,2381,7919,5837,8484,6907,8836,7904,5065,5066,7834,8580,7836,9058,4670,9305,9318,9269,9254,9333,9387,8220,5267,9421,9322,9365,9459,9509,9338,9479,9403,233,7928,6103,8628,4800,9366,9526,9641,9656,9763,9770,9028,9136,9527,9406,9798,6857,9648,9347,9634,9871,9930,9942,9750,9947,2985,9030,3479,9968,10008,9950,9935,6738,8776,10060,9978,10011,61,5477,3933,10061,10079,320,1268,1536,3162,3612,10108,10172,10128,2093,9951,9954,609,9439,9045,9032,7833,2137,10210,10228,9998,10221,1815,10303,1816,9214,9059,8891,3701,10354,10338,10307,10366,10375,9832,10351,8139,10482,9245,9807,8828,10523,10481,9373,2025,10615,585,3904,9043,10666,10648,5795,10258,6700,6548,10569,10244,10568,9904,8900,9831,8837,10548,8925,6713,10870,10880,10895,8888,8901,8902,10857,10767,9086,8089,10702,8800,10911,7828,10619,10620,10705,10621,10899,10142,10903,10935,7807,7878,7238,223,8436,8220,8171,7094,7713,7647,7647,5454,5454,6740,8063,7160,7548,3511,7716,8577,5134,8610,7655,9300,2263,9354,501,6158,5070,1461,675,4801,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,2932,6740,3830,1029,223,1183,1645,2615,2182,7210,8220,2063,5959,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,7175,8483,8547,8151,8019,7774,4983,6891,6715,3428,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,7982,1765,1771,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,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,8169,10565,8667,11394,8778,10124,8027,11134,11870,11290,11496,11851,11829,11825,11450,4535,4979) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC