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,5371,6190,358,6162,2635,52,6312,801,6843,3966,6794,6588,464,6644,6366,6135,6130,6168,6155,6177,6177,5881,2658,7238,7238,3262,2520,3550,6740,6349,7238,7238,8220,4597,6813,6725,7775,3395,714,714,6766,7783,7783,2029,8143,4801,4801,217,958,5995,5995,6710,8108,8108,8456,8456,8452,8181,8229,587,8782,4769,4769,3864,6691,8305,6103,8290,8547,7994,8554,4597,176,7639,7213,8561,5765,3590,5623,955,3843,6687,3415,2639,6875,1829,6643,2117,8514,7157,7585,1645,4774,8363,2594,7714,1783,6834,6834) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC