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,7649,7819,7116,6364,7740,5996,8372,7121,7079,8373,7094,8373,7265,7265,7100,7118,7118,7088,7105,8375,8050,7287,7106,7702,7654,6382,6382,7675,7094,9132,9579,7006,8203,5927,8576,6774,8771,6774,4639,4639,4639,2288,3598,6621,6175,5371,5956,6700,9340,6971,6691,6691,104,104,6477,8622,8371,6561,6561,8428,9482,9482,4683,4683,6977,6977,6693,9338,9338,9338,9338,10211,10211,10211,10496,10496,10292,9797,9340,9998,10078,6658,6658,9543,9543,8206,1662,8168,7286,10649,1770,10649) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC