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,4769,5996,834,1537,3913,5435,4437,4438,6602,1270,1153,10371,11207,11205,5784,1265,4128,2021,1650,926,1917,1461,3595,986,6190,6609,1462,1084,4767,1681,1461,4209,754,6705,5371,6809,4566,6845,6103,4046,4049,6245,1016,6561,6249,6980,6104,5717,4050,419,6248,6252,1815,2245,6804,6766,6589,6793,1526,768,6686,6588,2706,6679,2417,6635,6856,6639,6684,7138,1270,5148,6726,7156,2342,6674,916,6314,6595,2169,6792,5371,4023,6858,7158,3080,5339,2294,1895,1119,7050,7160,2923,2703,2123,5573,608,4061,2006,752,1349,1127,1253,8543,2933,8683,6713,4460,7138,1432,5373,7354,5812,4048,5266,3080,8687,8978,8925,8548,8910,5545,4652,4566,4258,8905,8795,5817,6684,9086,9030,6635,9000,9050,5339,5020,7126,4460,1349,1347,3701,8904,2933,9196,8688,9079,5157,6117,1299,4553,6696,9353,8632,9363,1298,6632,8442,9258,8102,9406,6698,3195,9200,608,5726,5349,3542,8978,6337,9347,2118,3159,2706,2956,8094,7685,8095,7691,6562,8147,6678,7224,7230,7690,6565,8289,6882,6571,6570,6575,6574,8488,6736,6990,2469,6567,9947,7699,9002,8993,8997,8997,8997,9003,9003,9003,4079,6870,6740,7238,9033,8220,8947,6774,1371,3531,5269,8613,7576,9951,4349,6426,9394,397,2029,8938,10810,6631,10670,979,7300,2889,6365,10296,41,11019,7912,7870,10649,7631,8027,7840,11295,3327,2627,6693,7307) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC