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,5927,8576,6774,8771,6774,4639,4639,4639,2288,3598,6621,6175,5371,5956,6700,9340,6971,6691,6691,104,104,6477,8622,8371,6561,6561,8379,8379,8428,9482,9482,4683,4683,6977,6977,6693,9338,9338,9338,9338,10211,10211,10211,10292,9797,9340,9998,10078,6658,6658,9543,9543,8206,1662,8168,7286,10279,10228,10034,5269,7659,7445,7445,8477,9660,9813,9313,10075,10074,10011,10011,10056,10056,41,9650,8182,8390,10526,8401,8859,10702,7444,10480,10614,10859,10615,10789,11668,9687,10687,9709,7792,9686,11380,9696) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC