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,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,1462,8410,8462,7745,7741,7742,8053,8047,8022,7093,7910,8580,6648,8547,397,8685,6272,5184,8055,7903,6596,4282,7654,8290,6259,3029,7123,6209,7097,7101,7115,4724,2023,5732,1490,946,4234,5148,2632,3241,501,5179,5799,766,640,7940,7943,7093,8064,7084,7946,1038,6981,7931,8393,7941,9634,9648,7581,9347,6117,8543,9798,9930,9932,9929,6857,6857,9637,9961,10784,10476,10149,10878,6235,6115,1777,7943,8430,8370,7675,8047,8067,8034,7106,8461,7250,7113,7112,7096,7084,7106,8055,9225,7675,7278,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,7089,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,7112,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,1116,1116,7660,8083,7068,7084,7084,8580,7088,7086,7661,7662,8063,8046,8034,8087,9543,9543,8864,9247,7659,9158,9158,8393,7656,7657,7931,8220,8268,8268,7984,7946,8398,8418,9574,9574,7932,7932,9148,8064,10023,8282,7089,8066,8066,8062,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,11704,8477,10027,10863,10212,8516,8892,8610,11918,11573,9204,10591,9055,9312,8713,7279,9756,7265,8475,10270,7666,10272,8458,8461,8537,7077,7971,7068,10789,7984,8393,8211,10659,10692,10588,7087,10588,7111,7115,7116,7117,7119,7125,7675,7895,8047,8048,10169,6131,9055,8770,9134,8739,9204,9206,9259,9529,10690,9563,11124,9578,11276,11471,9539,8063,11336,11337,9148,11059,11187,11469,11470,10906,8058,11376,7077,11034,11542,11035,7279,7666,8044,7077,7265,8213,7930,7280,7279,7244,10009,11555,8713) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC