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,964,8917,8884,6795,4558,8220,7207,9300,8255,2830,2830,6402,6004,6402,6004,6402,6004,5719,7708,9547,9546,8355,3936,3702,9053,7655,7655,7906,8077,9510,7668,8207,9386,9407,6631,7906,8955,6591,3282,8422,9577,4339,9659,7669,6629,810,6693,9292,5376,7159,1685,8794,9821,2913,9664,9813,9936,3604,8742,1992,2658,9354,9479,1967,9049,9933,9985,9526,9594,9594,754,7765,7880,2253,6876,7639,9029,8947,2522,4259,2467,1591,6788,7605,9342,5407,9061,3878,8689,9674,9547,6103,9757,609,10008,9959,9933,6781,4598,10061,10170,10211,6579,10655,1345,10537,10702,10718,8394,10356,7869,7869,5810,9488,5770,5770,2029,2029,2029,2029,2029,3913,8425,8236,8236,8547,8547,8438,8438,9308,9258,9366,9366,5636,114,114,6857,9347,9347,9554,9533,9675,8514,8514,6004,6004,1345,8175,6715,5269,7875,7876,9900,9952,9945,8306,9386,9942,6953,7067,7840,8459,8459,4346,4346,8514,8910,8732,7048,4178,10818,11028,6367,10649,10892,1777,6793,4362,9386,11253,10212,10505,9865,11219,11195,10248,9871,6240,11169,11217,10687,11379,9420,10831,5269,10002,10893,4716,10282,11349,11438,10164,11303,3210,10844,10731,11271,11272,8485,5602,8547,7576,11586,9386,11239,11266,11658,11655,10892,11437,2389,10983) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC