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,6766,7158,2029,783,7249,6004,2006,7834,7903,7998,4046,6971,8204,8204,6894,3824,7081,8087,7659,7149,8206,379,8290,8648,8648,8648,8547,8547,8547,8713,8706,7928,7928,8611,8948,3066,961,8198,8948,9053,9053,8415,8743,7670,9128,2261,8023,7118,7151,7675,2024,8447,7245,8444,8460,8765,8460,3385,8365,8067,8067,7074,9349,6806,8995,8995,6270,6270,2122,8787,392,8858,8786,8784,391,9481,7082,9418,4302,6842,3976,2118,7761,6842,6010,3532,3595,3169,8093,6713,6505,8185,2933,3542,219,8220,6314,1347,6264,8547,387,3823,7151,7019,7761,8222,7647,7151,8793,7109,7125,6192,7082,8365,8816,8727,7080,7663,7550,2337,4455,4234,8923,8888,9038,9030,4566,2976,8222,8220,7879,8450,7258,7953,7879,8250,8615,8926,8995,8990,421,8082,7953,9270,9271,7239,7281,9054,8084,7594,8361,9321,8083,7910,9315,9277,8222,8406,9469,9470,734,6168,8220,7238,6740,8998,931,8458,9527,9526,7070,7238,8401,6740,6740,8220,7238,7106,9552,8208,8891,8434,9302,9278,6386,3395,8439,1563,7022,3395,7904,8201,7256,3541,7944,8423,6731,1663,1663,1765,1769,5544,6740,1385,814,8423,10095,9261,9647,7907,179,3590,6828,178,10190,3380,5252,7094,10109,1645,8460,9571,3864,10584,4861,576,9058,6276,1973,8525,8525,8525,8525,8525,8525,8525,8859,7539,1084,427,1084,427,1084,427,7385,7385,7385,7385,7385,7385,7385,7385,1591,9524,1591,9524,1358,3863,9524,8563,7912,9862,7631,1767,7600,7676,8885,8618,6778,8436,8946,3070,3071,3073,7753,7752,8088,8627,4178,10292,10053,8306,5995,9867,8948,8947,6010,3913,3913,7833,9950,3913,9879,9614,9959,9770,9547,9752,9868,778,10080,9939,9933,8948,9991,9338,5269,6691,5936,10291,7639,3346,8828,9771,7993,698,7359,10312,10273,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,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,6599,10340,4146,867,10346,7913,2257,9939,10533,11971,9078,11660,11977,10760,11845,11494,10290,9463,11900,842,9651) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC