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,5602,6369,2915,3493,6276,4769,6402,3864,4437,4438,3913,1805,6926,6416,6938,6753,6382,8168,2282,6385,8203,7703,3247,6754,8055,8387,8401,7674,7069,8400,9609,6388,374,7704,858,1557,857,6373,6382,1711,389,386,8731,9156,8986,6391,673,2701,275,1711,1711,7040,8654,7198,6763,8881,8989,9088,9172,9173,857,1665,9782,9968,730,730,9176,9176,9177,10489,11363,365) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC