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,2932,3241,6586,1173,1038,1586,6716,6584,6408,6407,4227,6817,1793,5981,6100,5331,5371,7012,2869,1351,5576,6367,7546,6264,1591,7985,1998,7913,8777,958,7666,6780,7878,7666,8802,7036,8440,1559,4648,8087,947,6376,2262,310,359,5908,1300,8302,7175,6006,7350,1825,6585,6631,6611,6291,6098,6843,1732,2005,8230,714,7300,6715,5717,7920,6795,6569) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC