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,7883,7647,2989,1521,1954,2164,1559,4050,4082,3625,2160,2976,4218,5247,2932,2706,7835,7837,3142,3244,1163,405,8030,1718,1738,8182,8146,3479,4983,7654,5763,8150,8103,7761,1038,5732,1569,4452,7158,504,8222,8378,396,1350,1521,4082,6069,1906,975,1826,8089,8281,2381,2329,1907,8290,4834,4131,3003,8142,739,3288,2985,4710,6880,8547,6255,6855,2164,971,8721,8628,8629,4005,1920,1954,8492,1830,3744,768,322,4217,1134,2863,4325,2054,741,8763,5373,7594,252,2989,8890,8851,3625,4109,3715,2337,8901,5839,8089,8904,8936,8925,3195,6707,8134,8932,2934,2294,8933,1052,9009,9086,8871,5997,7981,4624,2946,9196,4767,1190,3026,2054,4240,9197,9249,8978,8795,8805,9220,8087,7121,8045,971,9135,9373,9366,9335,4136,8919,7138,5460,9466,9478,9477,9322,9455,8914,9539,9557,9578,9471,9464,4800,9353,9547,9607,9200,9332,9543,9654,7213,9333,9637,9680,9799,9798,9764,9769,3849,7640,9910,9904,9913,9914,162,9766,7391,7391,5995,7287,6484,6484,7090,7068,7108,7971,7072,7247,7946,7946,7107,7294,3036,8044,8049,7906,7282,7282,8086,7279,8081,7662,7269,7939,7074,4983,8220,7940,8086,7077,8571,8206,8206,7243,8381,8080,8198,8240,8240,8240,8199,7113,8197,7975,8083,8205,7079,8742,8742,8460,8580,8413,8413,7654,9719,9742,7105,2992,7076,7122,8782,8382,8768,8768,7261,9610,7261,7286,9608,9611,9793,9793,9743,7714,7714,8228,8449,8450,9560,8782,8782,10026,9950,9573,8363,8363,10022,10022,7671,10292,10292,8400,5995,8220,7108,7108,7842,8063,7084,376,8354,8765,8765,5996,8387,8387,7975,8093,7714,3860,8143,9010,8983,8071,9056,8982,8878,9049,7294,2780,7072,7261,7286,7122,7068,7094,7108,7107,7104,7283,7266,7081,7121,7154,7119,8240,8228,7946,8349,8207,8406,8396,7967,7279,7715,8790,7106,7278,8360,8439,8423,8423,7599,8404,7658,6382,7946,547,8459,7070,1769,1967,9076,8208,8362,8380,8463,8832,7076,3883,8050,7665,8201,7932,8394,4769,8362,7147,8220,8080,7110,7783,5602,8909,8055,7674,8087,7261,5961,8628,8836,8213,8375,7023,1379,7775,1893,8776,8378,8545,5927,8576,6774,8771,6774,4639,4639,4639,2288,3598,6621,6175,5371,5956,6700,9340,6971,6691,6691,104,104,6477,8622,6561,6561,8379,8379,8428,9482,9482,4683,4683,6977,6977,6693,9338,9338,9338,9338,10211,10211,10211,10496,10496,10292,9797,9340,9998,10078,6658,6658,9543,9543,8206,1662,8168,7286,8087,8206,7661,7662,8410,4774,7077,5923,6870,8828,3066,6691,7155,7077,8211,7077,9900,6971,9879,9879,8781,9949,8877,8878,9755,8200,8880,8880,7898,9537,9885,7304,9853,9890,1770,1770,10526,10526,8880,6845,6845,3029,6845,7297,6845,7297,7897,8498,7897,8498,10615,10614,10615,10614,8882,8882,10898,10579,9797,10858,10346,11215,10346,11215,7077,7287,7286,11526,7147,8377,7249,7088,9739,10007,7081,8571,8638,8641,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,9819,9820,9818,10095,8229,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,7903,5134,3913,3913,4739,8780,8780,8290,8290,7833,7910,7910,4796,3712,3712,4094,3389,8435,8435,1988,1988,2384,2384,6740,6740,4230,4230,7261,10228,9830,9674,9674,10482,9389,1142,1142,9387,10738,6548,8741,9975,10666,10907,6548,7261,7286,8229) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC