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,1770,9536,8245,10045,7610,10194,379,10335,10334,10217,6151,10336,10199,9408,9588,9589,9903,7570,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,9909,9087,10643,8011,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,8272,3883,10167,6742,6744,6751,6745,8982,8983,6749,6750,8879,8980,8981,6746,10045,10222,6386,6743,6914,1662,554,10272,9189,9076,390,9518,9520,9517,9521,9522,8985,9515,6854,7703,8986,8987,10427,10647,9144,10729,10763,10532,10763,10126,9580,10532,7238,9192,9191,9217,9231,9143,10957,9144,10958,1016,1016,6354,9907,7972,3070,3073,10036,4302,4305,5996,9906,9879,3071,6689,6688,7752,8088,8627,9037,9970,10254,8946,8727,10056,9665,10053,9473,9474,10298,9475,8698,8681,9670,9669,9671,9131,9673,9672,842,10477,8582,9906,9854,9888,9588,8899,8585,8982,3646,10560,10923,10673,9586,10910,10922,9587,10742,10520,10505,9137,9591,7762,8584,10561,10727,6388,11046,2913,11048,7631,10158,6146,10905,10433,6442,8589,372,8983,9515,10098) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC