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,526,531,542,524,1557,6385,8820,8007,549,6380,11301,11269,11247,11254,11022,735,11568,11650,11317,11318,10922,7083,550,547,11665,11791,11427,6527,10176,11051,11194,11244,11601,5383,3070,6354,10925,10923,810,10827,540,532,8788,394,8786,8858,6270,375,390,6076,548,6066,537,541,8880,8878,7693,11467,11611,8784,8787,391,6836,11081,11079,11080,11878,11877,11602,4282,11296,11075,11876,11077,392,538,11078,6076,10921,11173,11174,9523,11183,11667,10643,6076,11734,11792,4684,11791,4293,1768,11078,5535,4614,6785) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC