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,1769,6197,10330,6198,11221,6354,10822,10975,10981,8627,6689,7752,11242,10522,6199,10327,6201,6197,8856,3073,9412,11240,5297,11137,11138,11149,11204,11301,11587,10232,8585,8584,4293,10828,10836,11690,7610,6834,10232,9867,9522,10292,8764,9488,4724,11325,11121,7374,11354,11356,11081,9518,4305,9891,8584,10728,11206,9517,10555,11723,8824,4390) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC