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,5995,2491,3069,2658,6272,3384,5295,4795,1656,3385,2491,3401,5717,5175,6118,952,6103,3184,2998,2696,6453,5996,6474,6460,6465,6475,6740,2876,6468,222,156,6800,6390,6873,7104,2946,2453,7639,7938,7595,665,8281,7239,5545,7773,6493,8558,7674,7846,8724,8700,6498,8740,8682,8583,7840,9109,9054,8240,435,8913,9249,9249,3850,7647,9529,9619,5512,8953,8953) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC