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,4218,8305,6780,3549,2388,5334,8955,8019,5582,265,744,3850,2331,4964,4563,4164,4706,239,8995,9300,8628,8097,9647,5729,9864,9838,9897,9900,567,7634,576,7635,9381,10017,10041,10092,9617,10094,1912,2328,1029,1516,2052,5420,10141,6831,6899,1770,2117,1771,1766,6177,4535,9389,9387,6849,4125,9193,9235,10297,4563,10148,9914,4405,5917,9986,5305,933,2261,7299,9105,4947,3522,9126,8706,8560,10259,10535,8019,7822,9164,9065,10781,10236,4395,10021,8182,10823,10877,10658,10974,464,10937,9164,9065,10956,4801,3261,1092,5839,9941,10922,10912,10923,2808,2816,9116,2824,10505) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC