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,2932,6783,3241,6586,1173,1038,1586,6716,6584,6408,6407,4227,1793,5981,6100,5331,5371,7012,2869,1351,5576,6415,6702,6794,1462,5371,6648,6950,6967,6971,1970,3966,1085,6997,5848,1084,5142,4765,6367,5691,8,5951,2156,6129,6396,1885,1886,3531,6561,6223,6497,6138,7775,6223,6841,1207,8151,8435,3070,3071,7881,3071,7753,8088,7881,8467,7660,7268,7084,6550,6693,1982,8060,7576,1086,220,6975,1308,1511,8110,2169,2157,5959,4769,7657,2643,7123,5024,6139,850,226,6972,7846,2384,6264,2627,6102,7893,6890,8610,6103,6870,8445,8514,8460,5961,8424,7655,7715,7077,8289,8439,4774,8423,7605,8386,8398,8034,6,8400,8395,8423,8384,5996,8289,1645,3647,2992,6366,2467,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,540,536,528,543,544,551,537,533,550,6042,541,548,573,549,538,535,546,539,547,531,529,532,542,525,7920,7833,6444,2294,1825,7888,6548,8793,6844,6984,8887,8196,5858,5863,6578,6006,6631,3266,6312,6312,7708,2849,4936) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC