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,7989,7990,4395,4079,7880,7759,6779,5640,7008,232,7760,6986,4761,5235,1268,1345,3419,4985,8215,7607,8219,801,1988,3574,6648,6383,6176,3967,6984,6947,7032,7033,1153,1983,4923,1380,1296,6316,5719,2889,4362,587,2399,6583,7641,6726,7158,5769,8230,8109,1070,6366,3302,1988,5719,5719,3449,6428,6428,3522,8352,8352,7976,7976,7918,1526,6702,4694,9030,6122,7874,834,5961,6428,6428,970,4639,8358,9258,7238,8220,8741,4788,9378,8407,9727,9741,6119) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC