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,6176,5371,5998,6362,675,1402,3913,2261,4405,6811,435,4419,217,4784,3595,6667,1811,6003,2736,6003,3327,4639,2417,228,6821,6792,233,452,6275,7986,3059,3059,3059,5535,5936,3863,1049,6880,7391,7391,1537,7535,7563,7304,7731,223,5995,446,1298,5435,7953,2342,2342,2342,446,8306,7903,8290,8579,867,1772,9726,1772,9726,7505,7977,7505,7977,7505,7977,7505,7977,6282,1811,9857,1784,10731,11373,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,11880,1983) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC