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,5981,5995,6362,1126,1198,435,1234,2995,4778,1398,2451,6391,3581,7107,7077,8081,7298,7298,7245,7245,7105,7297,7297,7297,4178,1970,8446,6388,374,7704,858,1557,857,6373,6382,389,386,8731,9156,8986,6391,673,2701,275,6418,6418,7040,8654,7198,6763,8881,8989,9088,9172,9173,857,1665,9782,9968,730,730,9176,9176,9177) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC