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,2179,5947,9870,7925,6691,186,9296,10072,9052,1881,10449,10394,176,9915,9868,4233,4659,9887,2925,2123,3613,5640,10016,9931,9548,666,9005,10566,10013,10015,10017,10018,10108,10109,10110,10619,5959,9950,10315,10086,10620,9403,10621,10648,9481,10012) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC