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,2200,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,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,8556,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,8556,9563,10906,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,4146,7244,7278,7110,7091,7096,7079,7256,3402,7283,7967,7123,7298,1988,587,587,7114,7916,7083,7241,7241,7895,8064,7112,7254,7254,6127,7074,7093,7574,7069,7272,7665,8065,7674,7094,7266,8055,8753,8456,8201,8080,8050,8087,8385,8064,8769,8635,8736,8439,9560,9578,8407,6984,7671,9148,8363,7642,8417,9314,9259,8767,1982,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,2157,5959,4769,7657,2643,7123,5024,6139,850,6972,7846,2384,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,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,2171,987,987,1604,6727,1462,6820,993,4918,6578,520,7966,3863,1981,1296,1296,2041,1462,1981,5769,7849,1988,9354,9321,9354,9321,8434,8434,9630,9629,9630,9629,6715,3864,6715,3864,6971,6700,9931,9935,10211,9284,6984,314,7917,9306,8839,8767,9995,7649,8209,8768,6717,10301,6586,10730,3402,7159,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,10316,8130,10316,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC