thisMySQL 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,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,7834,7812,7879,7836,7878,3131,3428,6521,7663,7764,7762,5091,7568,3520,7570,7246,7569,1656,8071,1770,7151,6531,7650,7649,4301,4293,4289,4299,4286,4305,4287,4294,4292,7643,4302,7963,4297,4298,2766,5024,7079,1085,6103,6780,972,8300,5371,8531,1086,7599,3519,979,7906,8587,7568,6532,4804,8836,8814,1667,6306,8520,9038,8816,6618,9030,8092,801,7808,7102,916,7899,358,3647,176,7908,915,1385,1385,5947,1565,8220,7974,8110,7904,7605,2063,3250,7032,6175,5915,6832,8393,6210,8055,8055,7833,5848,6588,7903,1662,7023,2269,5688,8942,6618,2182,8948,5421,1385,8554,6785,6785,126,8940,7585,7175,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,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,8831,8597,8582,6807,7204,6958,6691,358,358,6100,2317,6103,4037,6632,5193,217,4901,8031,1439,8290,322,7961,7861,8541,5904,7592,2997,2873,7904,3926,8164,8164,8164,6191,6191,6750,4432,9038,858,3913,5647,8434,5732,9373,9549,7175,9277,9654,9335,9677,8688,8904,9197,9635,6337,834,2869,9636,9295,9149,9764,9811,107,1351,9651,9933,9680,8290,10064,8358,8358) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC