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,6204,4146,7089,553,7297,547,7107,535,545,546,547,548,549,3714,2997,7516,524,542,6569,536,536,6100,5914,7102,8055,8055,7083,7270,7270,2873,8408,8832,8832,526,2447,9632,7664,9107,9973,8363,8081,9082,10025,8185,2374,2182,7649,7819,7116,6364,7740,5996,7121,7079,8373,7094,8373,7265,7265,7100,7118,7118,7088,8379,7105,8375,8050,7287,7106,7702,7654,6382,6382,7675,7094,9132,9579,7006,8203,4146,7150,7150,5956,5956,8055,2520,1085,508,1371,6957,5956,582,582,582,582,176,1769,1769,6548,1662,1662,3598,6139,1885,6195,840,840,840,6963,10037,5305,3302,9212,6119,1345,2520,9213,7160,9079,2841,9079,2841,9366,8582,9366,8582,9258,7815,7605,9405,7605,9405,9028,4130,9028,4130,4199,4199,2555,9386,9116,9872,9116,9872,9563,8087,10835,9053,8709,9225,8770,9259,8457) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC