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,5143,8093,7587,5056,8737,9258,8514,4512,5909,9466,8175,9278,1198,9212,4784,4510,7599,9767,6171,9725,9730,9888,9888,9924,8933,5066,24,8308,970,5386,9182,8310,9593,9431,8874,8342,8340,8337,8333,8315,1765,8248,8326,8244,8241,8311,9889,8700,9879,1771,3071,3073,1765,10229,1771,1266,1769,8946,1411,1165,1767,9149,1769,1266,3066,6778,2605,7083,10522,7933,7122,7124,3897,3073,10056,3888,3892,7170,3885,7753,3881,3073,3071,4305,6689,10238) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC