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,3850,6158,4121,4338,6335,2594,1070,6350,4185,1520,5995,233,6010,5252,1380,2263,4218,5915,461,2261,4597,714,6001,6130,6589,6155,220,1038,5996,1537,6010,6383,3860,4860,5222,6559,7304,5148,5148,5088,5088,5437,2182,4395,6875,3493,6633,186,5142,7218,7250,7095,7273,7081,7271,4405,8220,3428,3428,2915,2915,2915,2915,2915,2915,7660,5956,5947,5962,8575,8453,8453,176,2169,8884,2093,2093,2093,6631,6740,1380,7241,7241,7241,6561,6561,7912,7117,7117,8832,7085,9049,9049,9049,9049,9908,1307,1307,1307,9386,10056,9931,1645,4076,6010,186,9296,10072,9052,1881,10449,10394,176,9915,9868,4233,4659,9887,2925,2123,3613,5640,10016,9931,9548,9005,10566,10013,10015,10017,10018,10108,10109,10110,10619,5955,5959,9950,10315,10086,10620,9403,10621,10648,9481,10012,4765,9647,9798,10002,10089,3549,461,10113,2164,5134,9921,7919,1371,10294,10261,6119,9296,10293,186,223,7632,10667,10950,10702,10360,10724,1080,7775,322,8305,8780,4535,10451,11130,11394,6898,10821,8820,10974,675,9297,10608,46,2658,11518,2071) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC