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,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,9042,3287,8314,7985,665,2522,8206,1988,3574,6383,6176,3967,6984,6947,7032,7033,1153,1983,4923,1380,1296,6316,5719,2889,4362,587,2399,6583,7641,6726,7158,5769,8230,8109,1070,6366,3302,1988,5719,5719,3449,6428,6428,3522,8352,8352,7976,7976,7918,1526,6702,4694,9030,6122,7874,834,5961,2503,6428,2503,2503,6428,970,4639,8358,9258,4156,1461,1537,6102,1537,6415,6702,6794,1462,5371,6950,6967,6971,1970,3966,1085,6817,6997,5848,1084,5142,3327,7021,1402,3883,4597,7656,7657,7123,7097,6869,7675,7658,7655,7121,7101,2522,2117,6947,6743,7286,8071,8041,7116,7287,8067,8197,3892,5602,6604,6745,7279,840,8210,8298,8040,8227,7971,7226,8391,1462,8410,8462,7745,7741,7742,8053,8047,8022,7093,7910,8580,8547,397,8685,6272,5184,8391,8055,7903,6596,4282,7654,8290,6259,3029,7837,1266,7834,7815,7835,6354,8547,3070,7579,4405,3071,1371,1771,1766,3531,3076,8627,186,8659,1461,6947,6103,7836,5763,2546,1016,3809,8583,3908,8584,4659,7870,8793,8716,7816,3536,4227,104,1906,3346,2467,8586,7189,5385,1887,4216,8825,4339,6824,7167,7580,7170,7993,7165,1771,1765,1769,1768,8578,4931,8437,7166,8627,5371,9322,9757,8108,867,1886,8579,6958,8621,1984,6738,7204,8650,5439,8196,8623,2643,8435,6701,8633,8255,8130,6820,8542,6959,8622,6960,8624,6687,6972,6973,6974,8112,2775,8579,582,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,6394,10687,9802,9909,9342,8828,10060,1097,6550,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,130,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,8964,6197,9534,8003,6332,8278,10727,10563,10559,9231,10646,10812,9892,10044,10426,10487,6212,7843,10417,10489,7844,7845,3890,10545,10389,7196,384,10381,6443,10520,8579,10040,6517,6216,8242,10925,7704,10923,10729,10560,10199,10558,10557,10200,3894,3957,1764,10823,8882,11080,4302,8274,8250,11091,4512,2555,8696,1086,4316,5003,10318,2039,4774,9386,2998,10486,6535,9493,11153,7299,10045,6143,10935,9903,10828,4827,5208,4645,9418,6986,10513,11106,10820,11198,11246,11067,11219,11230,10483,10924,11068,11071,8827,11069,11254,11296,11270,10921,11238,10931,11109,11306,10930,6423,10642,4299,9591,11048,9888,2605,10923,10922,8002,10644,10561,7762,4293,11156,4287,11317,8596,7676,10201,11320,10645,11321,11158,6521,10562,10647,10643,7987,3070,6354,11008,9535,6689,3892,3071,3073,2643,10937,11324,11152,9147,11432,11467,11479,4146,10426) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC