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,8460,8568,9563,7249,8083,8641,8086,10584,8657,10575,9082,10624,7258,10582,9187,8459,9134,9609,10869,10789,10906,7106,8430,8370,8424,10767,11045,8039,11187,10584,7071,11124,8045,11278,11277,7121,8056,10692,8739,8039,9054,7276,7272,11196,8370,8282,9539,9578,11124,7662,7661,11125,11276,7278,11334,11376,9793,8711,8431,10510,11472,11469,7241,11411,8711,11470,7574,11196,11525,11511,7108,9370,10580,10275,10271,10270,11333,7271,11526,8411,11300,8610,10888,10720,10976,6870,11189,8144,8030,7149,10011,7910,8208,4254,8892,5763,8891,5371,10768,11386,8370,11384,9557,8482,7280,1049,10869,1343,7277,9757,1016,5988,10007,10649,9739,9959,6103,28,7208,7247,9740,10854,10855,11188,4598,1308,7641,11277,8400,11402,11553,10906,450,10011,10694,11271,10510,11572,8577,8471,8547,10818,9136,11676,3908,10483,9563,10884,10372,8,11707,11634,11706,10275,7273,7248,11709,11743,8279,10270,10977,11746,11771,7088,11776,11376,10965,2447,11704,10789,8178,11818,11839,6264,8022,11840,11283,8891,11879,10051,4659,7281,9609,3967,11337,2847,9303,11927,8794,6103,11408,11115,11976,7285,1327,10274,11449,9312,8713,7279,9756,7265,8475,10270,7666,10272,8458,8461,8537,7077,7971,7068,10789,7984,8391,8393,8211,10659,10692,10588,7087,10588,7111,7115,7116,7117,7119,7125,7675,7895,8047,8048,10169,6131,9055,8770,9134,8739,9204,9206,9259,9529,10690,9563,11124,9578,11276,9539,8063,11336,11337,9148,11059,11187,11469,11470,10906,8058,11376,7077,11034,11542,11035,7279,7666,8044,7077,7265,8213,7930,7280,7279,7244,10009,11555,8713,7265,8213,9821,8213,9821,9821,7068,9821,8062,8062,7657,7657,9719,8050,8720,8450,10882,10882,8240,10890,10890,10630,11045,11096,10400,10399,10625,8282,11225,9058,10906,11124,10863,11276,11187,11331,11125,10011,9161,8573,8360,10771,10769,7267,10770,10862,11469,11470,7674,7670,11332,9225,11633,11626,11652,10689,7275,11630,9662,10854,10855,11700,11755,11757,11761,11631,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,9819,10617,9161,10807,8079,11332,11337,11535,10690,8430,9261,10572,10689,7272,10403,11542,11504,11503,11506) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC