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,6209,1016,8064,8766,8759,7765,8063,7111,7110,1591,8577,8306,8644,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,4898,2182,7210,8220,2063,5959,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,3172,2925,1232,2658,9422,6103,2627,6642,6103,6642,6103,5454,5454,5995,6845,5454,7910,5454,7910,4769,582,4769,582,5209,6381,1662,1089,8765,6134,6134,8716,8434,7852,4752,7810,3891,9159,2263,7974,3809,2266,2266,1089,1089,1089,8292,4337,9296,4432,8389,7218,6740,7828,8145,9382,3169,3532,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,1044,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,8926,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,8962,9011,8289,4906,8102,10170,11361,11690,10622,11742,11101,11402,6134,10667,8219,8830,8219,8830,8926,9822,9910,9811,9677,9654,9769,9614,9440,8979,9335,9953,8978,431,2093,1881,9950,9481,9951,5883,186,3625,9680,10046,10173,10116,3493,4947,7992,1520,10142,10142,5541,8022,5541,8022,5541,8022,9279,9290,10126,7775,10164,9417,10547,223,9736,1257,8306,11115,3913,1215,8358) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC