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,56,2343,7039,2263,6850,3574,1825,6139,2009,5959,8284,8926,7828,6794,7148,2263,8299,5790,5810,5952,5962,2343,6870,7640,6648,2998,1462,587,6690,6900,6779,6979,2389,6900,7139,6981,7142,7127,7141,5996,1537,7148,7268,7084,7124,5407,2776,4637,455,6267,3608,6437,317,7268,6969,2389,4460,538,8744,8354,4294,8585,9030,3287,8314,7985,665,2522,8206,7307,7374,7374,6004,6361,6361,4979,2458,2458,2021,2021,2021,4399,4399,7849,7849,317,4979,5303,9975,9975,10033,10036,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,1586,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,6810,9049,9049,8828,7375,7375,9318,8683,7286,6561,6561,6561,7371,10203,4769,7501,10296,11019,10292,6718,10992,207,10310,6406,11269,10940,11247,11118,10466,9716,10408,10490,9706,9718,11254,6603,9708,11051,11427,9690,10695,860,11263,11295,6361,11053,11467,10438,9384,10730,9936,6443,6271,11731,10721,8962,11727,8685,11792,7219,365,374,7806,6586,3823,6003) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC