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,7437,9090,7388,7390,8389,4316,4512,7422,2520,6715,8290,1970,9361,6700,6383,7493,7521,7976,8128,4716,8128,4716,8303,1777,8303,1777,7067,8303,7067,8303,7067,8303,6394,9350,8024,7916,6127,10211,10304,8113,3702,4769,5770,1270,3074,314,3913,9012,9667,4979,6616,8941,8942,2122,207,9476,9476,6613,3070,8292,8292,6615,10281,10281,6733,6550,6579,11364,1783,10248,6548,9543,11444) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC