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,653,6938,7195,6932,7644,7105,6935,8053,8166,7648,6930,7115,7278,8203,7693,6424,6423,810,9852,6968,6377,979,390,6962,6656,10201,9592,9733,6424,6423,6898,272,8820,6388,7311,7610,6600,6416,7922,8944,7881,9679,10232,6416,9383,10427,9867,6386,10232,10431,8566,6377,545,3887,537,7703,14,6200,7166,9902,8885,8693,8732,726,810,10613,10386,9172,10387,10098,9734,10420,9905,9735,10638,10383,9601,10429,9909,9087,10643,10645,8696,8232,10432,10644,10640,365,1411,4614,10421,10637,10334,2701,6332,10389,10433,9733,10520,10443,6381,6380,10431,7192,7190,10213,10222,10162,10725,9892,6385,7715,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,9988,220,10480,5770,4574,10038,18,9975,10301,8668,1662,4769,6727,6984,6804,10649,5858,10936,10984,10898,10736) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC