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,7389,7279,7661,7105,2749,8762,8896,3581,8243,8872,542,375,8786,1500,8951,384,1766,390,8334,8856,8332,323,9049,9182,375,8700,6744,8,8874,9274,6381,9501,9481,8307,6974,9686,6700,446,8436,8598,8317,8336,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,8387,7610,7697,7694,7695,7696,3442,7608,3515,8244,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,381,379,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,7725,7725,6388,374,7704,858,1557,857,6373,6382,1711,389,386,8731,9156,8986,6391,673,2701,275,6418,6418,1711,1711,7040,8654,7198,6763,8881,8989,9088,9172,9173,857,9782,9968,730,730,9176,9176,9177,10292) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC