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,8712,9257,9758,9614,9674,4800,8240,9888,9889,2032,9870,9959,9132,8081,9556,10003,9933,8460,10050,10125,8914,10175,8302,8278,8276,10234,10267,9538,10179,9325,10269,9205,10261,10315,9133,8275,10472,10499,9813,10538,10624,8199,10625,10021,10673,10513,10672,10741,7721,6031,8151,9721,507,6034,6444,3875,2025,3510,6855,228,10657,4128,8278,8943,7881,6354,51,4510,6880,675,11646,10802,1398,4788,30,9453,7036,2954,10892,167,4316,5003) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC