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,1453,2992,408,1663,2520,5827,7069,7123,7115,788,7591,7576,7833,382,6189,6742,6582,8268,8401,8401,7097,7097,365,8267,4861,8580,8580,217,7548,8790,3036,8394,8390,8390,8891,5882,8251,7897,9011,8839,8839,8438,2992,2992,9028,2992,8793,9139,3863,5742,3334,1973,5717,2145,5733,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,6484,9866,4742,9946,10314,10228,10871,8358,916,9771,3863,5435,5419,5385,10987,10687,9863,10976,10910,10985,11293,10816,10113,7752,8088,7881,8727,6688,10544,10679,11101,2253,11272,11289,3327,10865,10975,8946,10910,11373,7752,10114,11361,6103,4659,8088,892,10362,10670,6237,10228,6392,2969,3838,11489,7159,11551,9863,8586,10836,8256,9383,10687,11121,11325) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC