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,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,4898,6561,6832,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,1308,6193,7374,7759,582,1461,7760,7776,7872,582,431,7899,6312,7790,7889,7908,8031,7871,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,7953,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,7499,4742,7272,7368,7501,7122,8406,8406,7105,7304,5897,2041,7388,10572,10572,10211,10211,6718,5922,6240,3809,5446,2546,5936,3247,5953,5949,8087,8206,7661,7662,8410,4774,7077,6870,8828,3066,6691,7155,7077,8371,8828,6208,11114,7084,5564,6718,4724,4659,2830,10372,5988,6342,6190,10671,10483,10887,10888,7088,7281,8891,9659,7108,9562) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC