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,675,6263,6167,6663,3029,3585,5179,446,3613,801,1070,820,1498,975,396,6635,501,6766,6766,2706,5148,7238,7238,176,6984,4291,6633,2261,5331,3647,1461,4452,222,5998,4199,5717,2706,4947,1439,4602,4156,4860,5255,5255,2538,2538,2538,7880,7880,7880,4432,6667,1624,6593,7304,5331,6367,1653,6131,4209,1571,4355,3904,6863,585,8195,8171,6691,2021,8143,6484,4860,4144,7548,6740,8454,6968,766,766,8500,8500,8050,7640,9529,9529,9541,9751,9258,8585,9933,7071,10057,9581) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC