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,6396,1084,1086,1085,1604,5495,714,5495,2729,1609,7132,5185,6533,990,4346,7020,7636,6589,7636,6750,2018,7580,4563,7972,7973,6201,3380,6098,8098,8093,7273,8302,7639,2006,6843,6445,3521,7105,8199,8047,7895,8413,8514,9055,9132,3647,9206,8475,3169,9195,4796,8224,9900,9935,9879,9630,9945,2736,10547,10026,1993,10765,7976,10881,8053,7152,9134,9204,11798,11609,10466,11410,2171,1604,6727,1462,6820,993,4918,6578,226,520,7966,3863,1981,1296,1296,2041,1462,1981,5769,7849,1988,9759,376,8682,152,9553,9754,4437,9559) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC