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,11301,11249,10323,11269,11299,11301,9522,8273,10053,10330,3881,545,374,9517,535,9518,11836,11696,10544,7753,3884,11242,7752,9037,7546,3888,9521,3889,10827,3885,10565,9407,9920,6800,8627,543,3890,8946,11229,11301,7881,10975,11231,10920,11019,10921,11252,11174,3892,11167,11421,11938,10238,11799,10637,11922,11939,11493,11697,11938,6534,11933,10562,11575,9052,6536,6076,11734,11792,4684,11791,4293,1768,11078,5535,4614,11903,6785,11608,11750,6373) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC