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,11726,11727,11729,6689,11121,11497,2009,11022,9858,6800,9681,10687,11701,6733,10106,11836,11723,8727,10836,9870,9716,9685,9681,11227,10455,11726,11727,11730,11731,10106,9717,9710,11809,11742,11808,11811,9715,11810,11729,9713,9714,9688,9689,11855,9694,9701,9692,9709,11732,9708,4,10107,9682,9686,9687,6200,9633,6198,6199,272,6197,11252,11251,11186,11177,11176,11175,1770,1765,1768,1769,1767,1766,11229,10176,11231,11179,11178,7569,7570,7762,7568,7567,7764,4300,4297,4287,4289,4294,4301,11430,11429,4293,7845,7844,3073,3070,6354,6688,11836,6689,11792,8946,3071,7752,8088,8627,9326,7753,9037,6689,3071,8946,1097,2627,2627,6424,10250,10489,6719,653,7610,6836,3515,6240,10455,7311,11726,7311,11726,5691,7697,1250,10106,11727) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC