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,2605,5386,7599,5332,1411,1266,5297,1770,7808,7677,8682,8719,8717,1765,1771,1767,1769,1768,1766,8731,2522,6538,6537,6536,6535,6534,1765,1771,8585,8586,7870,8584,7546,8618,8682,1769,1768,1766,8816,2522,6689,7753,7752,8088,8627,3071,8682,3070,186,3073,3071,186,3071,186,6689,6354,186,8727,7753,8727,7753,3070,7752,8088,8627,3073,8814,8817,510,1368,7753,7751,8717,7972,7752,7973,8088,8946,9037,377,8681,8817,9084,7751,7972,7973,6362,8271,4178) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC