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,6636,3823,3555,1973,1357,3555,6631,6658,5145,1380,4920,1358,1526,2417,7219,7451,5907,5907,7815,7815,7815,3957,3957,8860,8860,8860,8860,8860,8860,4769,7646,6658,52,7150,7150,7150,2635,7256,7548,5996,8540,6740,6740,3885,7143,7143,538,546,529,6621,543,533,544,7833,547,520,7976,541,528,6042,531,532,536,573,6646,7966,6610,550,7815,4906,524,553,4716,540,1726,6394,8081,8080,7270,546,525,9132,9132,548,8917,8447,7576,7576,7576,10169,6667,6397,6667,6397,1779,1779,1779,1779,6367,2023,6367,2023,6367,2023,6367,2023,4529,4997,8230,9772,3081,3081,10010,9865,10010,9865,9902,10078,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,10769,8767,10757,10617,11187,8773,10614,979,9049,9259,10854,10292,1662,10855,8577,8290,8628,9767,8782,7646,9508,6701,9072,10272,9441,10400,10834,10891,8202,8922,7944,7655,10399,11514,10625,11534,7655,11601,11602) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC