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,7292,7293,7069,7152,7097,7082,7096,7121,7076,7967,7153,7153,7083,7281,8406,8405,8409,8406,8085,7666,7967,8404,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,8445,8514,8460,5961,8424,6817,7655,7715,7077,8289,8439,4774,8423,7605,8398,8034,6,8400,8395,8423,8384,5996,275,6743,6390,4659,6133,6821,1167,2263,6633,6209,6240,5566,3425,3896,5883,860,6382,6749,1970,6907,6904,5822,3882,3883,3891,7293,7270,3884,7124,3888,3888,3892,7124,7251,7292,3890,7094,1366,6493,7155,3891,7095,3893,7083,3889,7087,7072,7100,7122,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,7089,3892,4724,6821,7277,7251,8197,7986,7247,8393,1626,7088,8384,8449,8384,7663,8439,8577,8085,8206,8205,8401,7940,3895,8646,8412,8772,8080,8240,8368,8274,7649,7653,8737,4805,6209,9056,7713,3881,3883,4220,8269,5454,8468,7671,9053,6863,8461,4233,8271,4209,9132,9402,458,5484,3894,4519,8893,4800,7985,9481,5777,4690,450,1569,9322,8257,9418,3244,9915,9934,8268,8644,7108,9417,9793,9367,8229,10078,5484,8398,7105,7272,7107,7121,7288,7282,7282,7120,7967,7272,7275,8363,7155,7032,8240,8474,7298,7298,8395,7671,8384,8736,8771,8034,8083,7112,8792,8443,7574,8033,8253,8047,8082,8040,9259,8048,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,7082,7109,7075,8412,8208,7294,8052,8767,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,7079,1983,8129,9620,9189,9141,7241,7088,8283,9076,6961,9729,8365,9492,9730,9481,4029,9537,7124,7107,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,7931,7241,8076,8547,7087,8055,7116,8077,7656,7280,8066,8770,8358,8832,8053,7675,9161,7267,8358,8571,8087,9031,7087,8398,553,8770,7125,6130,7086,7124,9293,9793,10075,7111,7122,7931,7107,7094,7124,7124,6740,8739,7087,7087,9660,9574,8739,7656,9083,7657,10409,10475,10475,10074,10591,10588,10592,10774,10691,10609,10692,10889,10694,1242,6283,7162,7199,5717,8639,3702,8208,1537,8081,8274,5996,5996,8223,3860,6587,9030,8236,9032,2033,7646,3883,7260,7260,6594,7122,7083,7716,8423,8709,8832,8438,7775,7775,7926,7926,7776,6904,8743,9562,8929,9401,8081,8769,9370,8568,9817,9082,9082,8657,7079,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,9441,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,9817,8767,8203,8085,9083,7715,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11367,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,5576,6583,1207,6656,3385,3384,8693,8694,7599,4784,1967,4714,7187,5046,8665,1685,9137,3037,8071,7273,7660,8429,8034,10007,9795,9563,9873,7280,7278,8709,9225,7674,8909,7265,9053,7272,7278,9611,9610,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7539,7539,7539,7539,7539,7539,7539,7539,7539,7539,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,7388,7388,1307,1307,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8468,8892,8468,10026,9189,8425,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,11711,10400,11711) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC