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,4079,7783,6740,7147,6177,3760,5996,7146,7812,8143,7548,7602,2573,2573,2473,2473,6633,1371,7863,7787,4834,4834,1029,6001,7878,7878,7878,6589,6589,6589,2594,3913,6971,5915,6809,9078,9069,9071,8661,3989,8841,7995,501,9185,2261,8547,3830,2487,5179,5070,766,7962,8024,7953,9300,8354,6715,6312,6312,6832,6984,5371,1726,5371,1726,5371,1726,3029,10814,11831,11835,10988,10786,9164,9185,4936,8144,10715,11382,10088,11129,4724,11688,6785,7144,11905,9841,11848,11352,11440,11485,3523,2615,11919,11923,8095,11773,11774,4735,10679,11980,11977,11655,7144,11439,11971,11456) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC