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,5995,6140,2473,1325,7241,6381,524,7363,6383,6175,7651,3550,501,8142,8097,8115,6362,6110,8305,8305,8019,8019,6157,240,961,961,961,961,8223,8223,1402,7900,6780,8706,8706,6310,8967,8514,8514,7911,1052,1126,6118,1371,8290,8151,5334,435,5251,7658,1379,8628,8628,4079,7783,6740,7147,6177,3760,5996,7146,7812,8143,7548,7602,8519,2573,2573,2473,2473,6633,1371,7787,4834,4834,1029,6001,7878,7878,7878,6589,6589,6589) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC