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,1520,3598,5380,254,5915,6138,5322,409,5763,2092,6361,6190,2897,1084,179,1740,3492,3395,2171,452,2145,3863,6947,587,217,4566,6803,2749,7044,7009,3595,6957,7208,186,6890,1645,1511,6561,7215,6624,176,5070,6812,5956,7159,5081,7579,4419,5897,5998,6003,6195,5956,6896,6587,6843,6102,1242,6173,1591,5912,2749,7046,6718,4971,6559,6548,6637,6550,3864,1787,1784,1775,1783,6000,3913,1786,1772,1805,1796,6102,4362,1766,3896,3913,6616,1462,6548,5371,5454,6691,5437,6190) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC