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,6629,3287,5134,5134,5134,6740,7390,446,4178,8514,6163,961,961,7877,7897,7124,7122,7122,6561,7079,7079,7985,7985,7913,8171,4079,8438,8438,8090,7884,7884,7884,7665,7150,7499,7291,7975,7122,7154,7107,8033,8228,7247,7654,7100,7967,7155,6718,7298,7906,8205,7106,7103,7251,8361,8580,7297,8208,389,7270,8381,8425,5936,7674,7967,7294,7079,8203,8828,8407,9049,7096,9158,8047,7266,8207,8203,7642,8413,9141,8980,8879,8981,8982,8983,7704,9146,9882,9794,9892,6744,6749,6751,8410,6746,6386,9176,9762,8581,9177,10097,10098,9821,10189,10095,10078,9733,9088,6854,3894,3893,8784,387,392,6082,372,365,8530,8529,8201,6076,9217,4305,10161,5995,7913,10263,10213,8882,8788,8786,8451,9229,6561,8496,8609,9900,6971,9879,9879,8781,9949,8877,8878,9755,8200,8880,8880,7898,9537,9885,7304,9853,9890,1770,1770,10526,10526,8880,6845,6845,3029,6845,7297,6845,7297,7897,7897,10615,10614,10615,10614,8882,8371,8882,8371,10898,10579,9797,10858,10346,11215,10346,11215,9067,10381,858,10846,10161,8345,11051,10676,10176,8878,376,365,5810,9975,10033,857,858,3254,6754,9004,8231,8941,8941,4362,4362,4362,10065,10065,2342,2005,7238,10056,4544,2324,11069,6733,6800,8002,8860,7416,7503,10033) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC