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,5784,1265,4128,2021,1650,926,1917,1461,3595,986,6190,1462,1084,4767,1681,1461,4209,754,6705,5371,6809,4566,6845,6103,4046,4049,6245,1016,6561,6249,6980,6104,5717,4050,419,6248,6252,1815,2245,6804,6766,6589,6793,4086,1526,768,6686,6588,2706,6679,2417,6635,6856,6639,6684,7138,1270,5148,6726,7156,2342,6674,916,6314,6595,2169,6792,5371,4023,6858,7158,3080,5339,2294,1895,1119,7050,7160,2923,2703,2123,5573,608,4061,2006,752,1349,1127,1253,8543,2933,8683,6713,4460,7138,1432,5373,7354,5812,4048,5266,3080,8687,8978,8925,8548,8910,5545,4652,4566,4258,8905,8795,5817,6684,9086,9030,6635,9000,9050,5339,5020,7126,4460,1349,1347,3701,8904,2933,9196,8688,9079,5157,6117,1299,4553,6696,9353,8632,9363,1298,6632,8442,9258,8102,9406,6698,3195,9200,608,5726,5349,3542,8978,6337,9347,2118,3159,867,223,6102,6103,5303,3531,409,450,6138,6548,2032,3337,2399,244,1740,6693,417,6774,1520,1198,232,7302,3531,417,6977,1785,6700,5576,1351,6977,6785,4226,6700,5046,6691,834,1793,5371,6550,7214,6102,6642,714,5951,2092,3863,8251,714,7717,7269,4337,984,7287,6769,8063,579,2023,2023,8182,8220,7262,5732,6840,359,1524,7861,9057,6738,2546,2122,6197,397,9499,8672,7068,9496,9502,9763,6965,6966,6110,6969,6968,7805,6970,3029,4944,6383,8349,8523,6621,8352,8357,8354,8523,8356,6969,6815,4146,1052,8839,4460,9017,6808,5719,9851,9620,7920,8031,7919,8514,8134,7927,3195,4005,1698,8103,8222,405,444,8220,8183,8306,7871,783,7927,8509,6809,6845,1906,6104,6069,4710,1907,4983,6117,6679,8615,8548,1349,4652,3744,8105,2723,7156,8688,8837,8902,8681,4136,8777,6402,8957,8956,2882,8973,8547,9045,748,836,7138,8999,8910,9086,4535,1005,609,754,8683,1591,8690,7992,3702,9220,261,2117,7607,6857,6842,9372,2025,6693,4801,7974,7976,6714,222,2387,3625,4362,1257,6104,223,5995,7083,7078,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6616,6603,6603,6603,7655,8251,7089,10406,9793,7715,8791,8646,8412,9441,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,1811,1811,1811,1811,8139,5000,6547,6547,8508,6603,3327,5988,9667,10831,6580,4769,2029,10375,10627,9751,3336) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC