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,2417,7219,4607,7451,5907,5907,7815,7815,7815,3957,3957,8863,7562,7506,7566,7400,7505,8292,3913,7541,9488,11308,6438,11329,11410,9004,8231,8941,8941,4362,4362,4362,10065,10065,2342,2005,7238,10056,4544,2324,8498,11069,6733,6800,8002,7416,7503) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC