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,7587,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,6621,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,8574,9710,9258,10023,11222,11101,3913,7088,8771,6806,8419,11315,8689,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10761,10220,10675,10767,2085,10869,10947,5922,3346,9888,9850,11227,10681,11227,10681,4800,7385,10682,10682,9868,11227,9300,10056,9681,10836,10836,9681,9305,9403,9915,9616,11121) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC