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,9430,9535,9591,2778,2783,2791,8591,9588,1770,8899,1766,9590,6354,8946,2823,3073,3070,3071,2828,2824,6689,7810,6220,6688,6221,9299,7083,8088,8087,7106,8627,9037,8071,9793,4752,10056,7169,8618,9906,9349,9970,10253,9149,1769,9418,8306,4178,9907,8820,1257,1210,10256,7100,7092,151,10254,8683,8816,814,5567,8894,9873,52,5995,5227,7714,9401,4784,4788,10347,5839,8460,3493,675,5516,9601,10342,8716,4639,8681,5386,8698,1411,1266,8817,1685,810,5297,1685,14,6076,8154,8816,4512,8683,10431,24,1210,8815,5792,10520,834,7568,30,8730,7567,6689,7569,7570,7762,7764,8826,4804,9720,1589,2766,8822,7006,8278,10188,9906,9958,8814,10043,9970,10253,11031,10256,11032,10367,9354,9907,9629,10254,9630,10251,8826,10432,801,8358,9601,7959,8142,10868,223,9789,2818,10255,5484,2824,8814,2812,10569,8257,9348,11028,9678,8293,8520,9924,6113,3465,10146,11237,9221,9374,9807,9808,4639,7953,8809,4639,452,9000,11414,10877,9215,11388,11437,11443,10697,11163,11477,6689,11129,11600,11656,11658,11660,11659,11662,8888,10892,10895,11488) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC