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,3702,6547,5046,778,7159,7301,6868,5897,6548,6189,5915,2145,2849,4682,2849,4682,6365,6001,1000,6102,2546,1398,5770,7505,7505,7301,7301,4639,7374,7374,820,820,6613,5996,8306,8828,8828,8828,8828,8828,8828,8828,8828,7130,5421,8973,8973,8973,8973,8973,9471,1771,1770,10041,1771,1767,1767,1767,1767,1767,8864,4199,6809,9391,10892,10543,5376,8515,7300,6646,6176,7032,5402,6611,6611,6774,6733,2029,6547,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,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,6102,8893,6693,6774,6395,6863,5303,6845,6104,2608,6006,6006,6977,7215,6173,2761,6173,8278,8278,4419,4419,4419,4419,4419,4419,4419,10342,9950,6392,6276,4563,10704,6843,10909,10676,10687,7804,9857,9513,9006,10539,2157,5000,9062,9803,3609,6237,10539,10566,6291,8256,10670,10940,3838,10940,3838,7300,4834,7300,4834,7385,10886,10539) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC