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,1250,2093,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,7097,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,6832,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7993,7804,4339,2027,7715,7079,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,8141,6193,8141,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,7086,7080,7119,3874,7385,2179,7108,7292,7292,7096,8050,7104,8061,7298,7642,8060,7297,1366,7106,1366,7107,7122,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,8443,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,4801,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,1645,547,7849,3865,4931,6798,531,551,510,6491,3071,7676,2374,1732,8003,532,546,3428,7239,7809,1385,7828,7583,156,4682,6136,9061,2117,2041,6583,6561,8115,8115,9169,9169,5484,6004,7979,8280,8091,3395,7890,6170,6364,1209,4535,4251,3148,2946,6209,7775,4724,1385,2521,8027,9118,8425,223,9299,9234,4774,3783,156,5245,6788,2266,9557,9741,7245,8400,9978,9652,4985,9989,10293,1990,4989,10304,7639,6610,8437,9116,8915,8887,6820,10666,10705,10669,10721,10670,10301,4325,4412,6622,9045,9299,9600,9926,10145,9804,10550,10370,1982,3074,9342,2328,4346,3389,9386,10505) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC