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,7100,8439,7068,6613,8568,8459,8740,8406,8080,8060,8061,8400,8060,7116,7666,8571,9084,6689,8283,9082,8283,9142,8055,7286,7123,8431,7106,8041,3073,3071,6689,7753,8088,1324,2041,6583,6561,8115,8115,9169,9169,5484,6004) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC