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,2145,3197,5564,6832,6737,3250,5717,6361,6369,6190,6583,6402,1788,1788,6799,6714,6102,7008,7008,4227,4227,1786,1786,7012,7012,5000,5000,7003,2912,6582,7738,4362,6740,7238,5995,7840,5996,8220,6693,4432,7897,1604,8015,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,7020,2944,2387,7238,6821,4624,7951,4901,6658,5131,4406,8222,1380,1947,6603,1973,1787,1777,10296,6603,9481,9222,10111,6700,5269,10766,7785,10386,8168,11227,7026,6854,9684,2349,2145,3327,11215,3327,11215,11099,6826) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC