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,4639,7304,2998,2998,2069,9879,9879,9879,7815,4659,8435,51,6715,7273,3701,5477,1970,1970,1886,7273,6579,7473,7350,6548,9029,7585,8505,7068,8206,6629,8472,10583,9536,8665,6381,8731,8387,8654,10257,6505,6533,6536,6534,324,788,8770,11124,11798,8055,10920,6879,11611,4297,2778,2816,2823,2787,2791,2779,4463) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC