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,7069,7976,7286,7992,7081,6642,6642,4209,8063,8807,8827,4778,7614,8910,8948,1198,6718,2913,7830,6693,9308,7561,9229,9366,8257,7383,3014,8733,8185,8477,2705,9725,5331,2253,961,9799,9813,7123,6174,3074,1172,7563,8865,8865,8865,8865,8865,8865,8865,8865,8876,8876,8876,8876,8876,1765,7388,7390,7390,1770,7288,9022,7388,7388,7563,6778,8175,9880,9554,6579,9991,7420,7486,7388,7431,7506,8865,8864,8868,7390,7150,7286,7079,7293,3884,7083,7281,4752,7124,7297,8051,7256,8059,7265,8070,8084,8206,8425,8425,7283,7283,3647,8359,8359,8425,8765,964,964,8409,52,52,52,7890,6216,8041,8034,10264,8047,8048,10008,9719,9853,389,8476,10185,10404,10510,8400,10604,10597,10601,10596,9794,9076,8419,9059,9082,9662,8404,10011,10029,9247,10767,7282,8227,8472,8471,8475,9367) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC