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,3100,5717,3401,4769,7118,388,7119,379,820,6381,1557,3897,6270,3893,4452,6600,3884,3894,8034,3889,3891,3892,7117,8047,7693,7975,7100,7155,7654,6272,6195,8050,7096,3881,7304,7920,1774,1775,665,1786,3108,3105,3105,8130,1782,1779,9796,9857,9791,4985,9989,10293,1324,1990,10600,10600,10598,10601,10596,9067,10612,6840,11091,8168,11069,11080,11075,11079,11076,11078,545,549,11085,548,11077,9189,9076,9794,4997,970,2137,11095,8782,8771,6740,9052,8940,7175,11948) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC