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,10111,10111,10111,10111,9978,6521,6719,6761,864,5691,6527,1165,6522,6518,6538,6520,6218,4282,397,6985,6719,1767,1704,4298,1685,7576,1084,979,6656,3442,2951,6800,4121,6376,6768,4296,858,397,3875,4286,4289,1967,3863,4121,857,6985,5297,1411,735,8245,6521,6527,397,7201,7599,8243,6261,6512,8314,8318,8317,6359,8334,8320,3875,8582,4931,8249,8490,7365,3510,7751,8729,8694,8692,2779,7300,2828,5635,2783,2826,2827,8597,2815,4804,7180,7184,2803,2805,2806,2808,6222,8654,8655,8816,8696,6521,3828,6542,6381,344,8531,681,6376,2876,8355,8353,9343,8874,9129,6444,6409,8698,2218,1266,6276,9041,8324,7721,810,2208,3337,6540,8882,382,1084,3327,9949,10037,7721,10032,10263,7204,2169,7697,1704,7693,7840,10696,3327,8490,8507,10698,10579,6925,8156,1084,7721,7966,10983,6988,6922,582,6929,6925,11406,11407,10324,11677,10742,11427,9141,834,9581,8206,9997,9951,7767,10061,5564,8639,10029,4659,324,8772,9998,9989,9763,9579,8229,8063,8928,8922,8628,8050,7112,8792,8431,8510,4544,1828,1726,9968,9959,8650,8364,8287,10379,10402,10693,10694,10590,10592,1917,9614,9977,1586,3595,609,10212,4788,4785,9533,4791,4784,2451,1210,10526,9300,10056,4639,10836,10742,10038,10758,10037,10279,10496,10228,5269,11482,11548,10036) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC