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,11140,2164,10532,2820,2779,2816,7982,9543,8822,10935,9133,10891,7170,5839,3874,4146,10302,11134,11010,10912,220,7911,10313,11198,10236,10363,10865,2390,6805,10294,11233,9759,11371,9014,10900,9824,11372,11360,9121,9087) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC