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,7108,7656,7660,7085,8230,8230,7152,7574,7100,6971,8058,7647,7082,7671,7671,6726,8066,7271,7271,7271,7117,7102,7121,7906,8576,7936,6740,6740,8065,7091,7263,7150,7125,8109,1371,7252,7253,4752,7644,7643,8080,8080,8080,7104,7124,7648,8081,7261,7088,7088,7088,7658,7286,7975,8041,8041,8713,7078,7120,7261,7150,7077,7109,7655,7099,7155,8832,7295,7661,7662,8771,8771,7111,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8439,9956,9583,9583,9583,7587,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,6621,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,9710,9258,10023,11222,11101,11286,3913,7088,8771,6806,8419,11315,8689,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10761,10220,10675,10767,2085,10869,10947,5922,3346) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC