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,9610,9611,9563,9510,8268,7660,9608,8438,8202,7659,9158,9609,9818,7655,8408,9457,8475,9539,7097,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9741,7118,9795,8381,9719,9259,8709,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7089,7646,9053,7297,7119,7096,9564,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,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,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,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,9818,7097,9526,2032,8169,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,7271,964,7281,7095,7032,7262,8839,8204,1511,8472,4558,7296,1172,7280,7068,8419,7285,8423,8474,8770,7275,9049,8712,9508,9508,8439,8409,7674,1089,9793,783,8782,8229,9620,7286,9658,9658,9619,7279,10007,10051,10185,9817,9817,8207,9956,6778,6778,10272,9577,9813,9957,9562,9510,9818,10271,10401,9053,9312,8237,7285,7289,10407,10888,10891,10843,8929,8468,10302,10789,8395,11058,8646,7069,4752,9817,8081,10077,7674,8036,7574,9748,9747,9746,9818,9820,5995,7268,10272,8141,8087,8431,8741,9998,8082,8743,9316,10451,8207,10464,9300,10056,10836,10890,9056,10450,6240,9563,9817,7279,9820,9818,10437,8286,8369,8658,8048,10586,10588,9132,9133,9619,9620,9621,10768,9622,9746,9747,9748,10835,9293,8477,7085,7661,7662,7077,7068,7258,7249,8626,8734,9247,9326,923,6981,8214,7873,9275,7981,9304,6955,5903,812,311,261,4944,9404,7065,9423,9329,7994,6364,208,9381,2976,6192,206,9013,5011,2507,5885,8151,3195,9421,7719,2882,9334,6838,7839,9243,4985,9260,9612,9069,8957,9198,9200,8187,308,9327,7893,9202,9213,9538,9202,9601,9883,6113,9544,7175,7892,7874,1537,10190,7970,5917,9390,4412,9449,9759,9080,1097,8554,6139,9283,9646,8551,10085,10124,10123,10126,10177,10183,8098,9009,10294,10302,10493,10261,9,8956,7907,7861,7299,10490,10501,4694,10612,10541,9406,8231,8963,10543,10531,8514,4795,10021,9664,665,2168,10816,10818,10819,10847,8144,9919,10814,9343,10978,10844,10954,6891,10741,11064,10976,11216,11222,11010,11025,8055,7080,7112,7664,8368,7084,7244,8033,7241,7280,8572,7932,7081,8647,8065,8642,8448,8417,8769,8635,8645,8405,8049,9161,9793,10022,10577,9973,10586,10617,9161,10807,8079,11332,11337,11471,11535,10690,8430,9261,10572,10689,7272,10403,11542,11504,11503,11506,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC