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,6774,6733,2029,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,3702,5046,778,7159,6239,7301,6868,5897,6548,546,7172,7639,7400,7541,7541,8103,2824,7104,7459,7459,7445,7449,7422,7422,7537,7537,1811,1811,1811,1811,8139,5000,6609,6609,6609,6609,8508,9386,9031,2052,7214,4639,9049,7155,9258,3389,6823,8232,7048,8544,8303,7854,7493,9899,5484,10292,4510,8303,4784,10039,9258,8949,7376,9007,7806,4557,7218,10000,10811,9649,1016,9441,7505,10768,9866,11373,11661,10687,11385,3582,9603,10836,10056,11402,10707,8517,6870,10187,10702,9856) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC