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,5252,2117,4417,1318,2117,3250,423,1831,3520,5305,2985,6845,6104,2780,2785,6996,3070,2518,3555,2342,2374,6999,243,219,1245,5088,6390,7785,7926,7870,6633,7761,4931,7796,6982,7774,8351,4395,7989,7830,7713,7115,7116,7152,6971,501,7878,8048,6261,8503,5795,1461,7761,8222,3059,2709,8924,9362,9374,9374,8584,2706,4861,9831,7107,8251,8948,10265,10306,9748,9890,10555,10479,10577,10862,10937,11325,8208,11497,10817,7541,10817,7541,10455,9692,10455,9692,9694,9694) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC