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,9347,6691,9220,9638,524,524,524,10042,10244,10243,8139,385,8882,380,8878,378,8329,6204,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,10054,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,7388,8768,7268,7268,7485,7485,8740,8740,8740,7662,7661,8721,1497,10166,8638,7674,9817,8444,7114,9719,10272,10507,9547,1770,2261,8303,7048,8544,8303,7854,7493,6547,7026,7388,7388,7388,10235,6925,6926,6922,4227,3840,653,10339,4419,10169,11284,11299,6935,858,11238,4226,11410,857,8389,9767,3327,8596,51,10857,10986,6102,10610,9024,7535) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC