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,7387,7421,7385,7459,7470,7437,7565,7565,7387,7387,7561,7501,7548,8223,7219,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,7155,7281,6413,6414,2389,7387,7066,7594,4544,7421,7672,8203,924,7374,7565,8363,5454,156,8206,8206,8839,6364,2992,5996,3803,7897,1349,8859,7238,8864,7647,7155,7110,8477,8063,8423,7068,8047,7258,8406,7574,7654,8049,7446,8208,9161,9161,8269,9398,9398,9247,9247,9049,2627,2627,2627,2627,2627,2627,4639,4639,1770,7486,7486,7486,7486,7486,7486,7486,7546,8863,3334,3327,4598,3913,5516,5732,6557,4411,5322,6255,5331,320,5988,4046,4199,4452,3201,520,4574,585,4432,3933,3440,4987,5020,6863,4233,2025,4805,6553,840,1490,6554,5647,6552,4337,5693,6880,6243,5573,2703,2397,4918,2324,6556,4209,7350,8435,2546,8463,6968,368,7985,7986,535,8832,8782,4037,6869,4798,7592,8917,8034,8240,8948,2913,7599,7521,7485,2261,3201,3888,3895,3892,3885,3891,3889,8272,3883,5609,6493,9300,8877,8274,7294,8839,9072,2737,1173,6174,6905,9437,1487,9438,6650,4121,8257,9439,9373,9459,6100,5,4708,3990,450,539,7501,7427,7485,7485,7565,7521,7441,7427,7409,8715,9272,9481,9482,9751,7459,7541,6367,10613,8092,587,10908,1361,7247,7241,7241,7069,7467,7467,7506,7506,7437,7420,9019,9019,9019,9024,7501,7457,7457,7457,7457,7457,7457,8861,7389,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,11215,10707,11380,3105,3108,7383,7409,7408,7406) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC