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,9970,9970,9970,9970,9970,8612,2349,6667,6397,6667,6397,1779,4607,1779,4607,1779,4607,1779,4607,6367,2023,6367,2023,6367,2023,6367,2023,4529,8230,9772,10600,10600,10598,10601,10596,9067,10612,6840,11091,8168,11069,11080,11075,11079,11076,11078,545,549,11085,548,11077,9189,9076,9794,4989,970,2137,11095,8782,8771,6740,9052,8940,7175) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC