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,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,8498,7704,9146,9882,9794,9892,6744,6749,6751,8410,6746,6386,9176,9762,8581,9177,10097,10098,9821,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,10591,10659,10774,10615,9957,10807,8928,8438,9973,10007,10011,10009,10854,9875,9876,9877,9874,11064,11065,9878,10029,10625,10835,10834,10965,9744,9796,9821,10811,11108,11063,9955,10888,11187,11196,9148,10623,11210,11212,10614,10855,7576,10617,11525,11331,11500,11892,11211,11376,11211,11376,11884,11512,11867,7714,11889,11894,11911,10833,9956) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC