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,7102,7095,7088,7110,8082,7653,1981,1981,7254,7113,8430,7674,7277,7574,7895,7288,8385,8472,7589,8464,7147,8047,7106,7767,7765,7092,7079,8645,8742,8269,8381,8072,7931,7932,8475,8477,3874,7646,8641,8640,7286,8363,8067,7068,7279,7108,7068,8366,8456,7071,8573,7672,7941,7941,8394,7151,7244,8373) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC