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,5305,1038,6669,5647,6998,2932,5995,4796,5148,5995,1351,975,2869,5735,943,6663,4128,2469,1822,2390,7034,1520,6827,3181,1829,7233,3302,3778,2331,7001,4947,3843,7787,1245,2571,2635,7160,6104,3384,6845,6858,7594,4555,5719,1070,3522,7904,6898,7304,242,3380,7838,3860,4405,7897,2992,7879,217,7548,7605,3549,8839,1516,7840,7004) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC