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,4234,6533,4432,6532,8361,5732,6223,4224,8323,501,8324,8596,1536,8425,8325,8404,7570,6751,7568,7762,8249,8248,8322,8245,8318,5235,8246,8683,8317,8323,320,8319,8247,640,8597,8358,5334,665,6780,2117,3549,2628,446,4765,7840,7879,7878,215,4574,7641,5839,3850,6785,5484,6723,4570,3479,7607,4178,8,7607,8306,6569,8912,9321,217,8305,1591,6569,6605,793,2573,5848,4788,6560,320,947,4199,6130,1453,1521,6117,1038,1086,4337,6776,2447,6700,3184,7374,4510,4987,2384,5439,226,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,7292,539,6689,7069,8047,7878,4399,7840,7169,9052,8547,9366,9362,9746,7112,766,9552,9796,8071,7089,10048,10056,7019,3159,7953,9833,9945,8514,10146,10130,9116,10836,9563,10906,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,4146,2594,9711,9717,11113,4395,1992,4395,1992,10363,11468,10667,6891,10667,6891,2052,4563,2052,4563) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC