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,4985,9988,384,8081,28,3882,8628,554,391,7967,9788,9962,9888,9403,9771,8831,6806,9872,6831,8520,8815,7970,9884,122,9898,5635,4386,9790,9835,2761,10181,8814,8730,4512,2024,10236,8826,7824,7820,9786,5917,9883,9967,9202,10182,9612,9736,9959,9868,2168,6850,8541,8389,9767,9310,9627,9117,5371,389,3073,6354,3070,6689,7753,8088,7752,8822,2999,8172,5363,8627,9037,3071,8780,10519,9870,8515,9496,10685,9391,11074,10868,10552,9168,10041,9295,10672,10673,4510,5872,10961,11073,7130,9838,8972,9215) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC