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,6615,4639,4639,4178,9829,10817,7238,10649,6740,8220,11383,8780,10672,4405,10314,11271,501,9094,11484,11497,11518,5567,10687,5175,10764,10802,9325,11645,2389,11772,10892,7937,10349,11644,3493,11219,11455,10798,11646,1520,1296,9305,9993,10229,10548,958,11353,10719,3401,8690,10346,7205,3702,6843,6102,964,6561) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC