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,3165,8257,7874,7970,2473,2915,4784,4701,9079,5380,9365,7218,4639,217,9904,9938,9937,1257,7903,9525,2658,9647,9900,9666,9922,9959,10000,9931,9366,9052,8948,2033,7143,5647,3830,9027,8793,1766,9829,4405,8087,10835,7106,10629,10919,10965,10992,11020,11092,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,551,6784,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,531,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017,8582,2808,2812,2781,8154,11071,11067,9555,9554,8241,8244,3784,2817,6354,3070,3073,3071) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC