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,4178,858,6545,6840,6763,6764,6765,3090,6144,6753,6761,6762,6759,6760,6840,6424,6752,6719,3609,6750,6742,6391,6746,6744,6749,6745,6911,6910,6914,6913,3926,6422,6758,6421,6424,6425,6932,6938,6925,6926,6912,6427,6423,6763,6764,6988,6934,6937,6928,6758,6911,6757,6756,6391,6753,3247,6917,6719,6763,6764,6765,6762,6761,6414,2282,6932,6754,6752,6423,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,6426,2282,6756,6191,6911,6758,6763,6756,6932,6926,2274,6757,2275,6423,653,6938,7195,6932,7644,7105,8053,8011,8166,7648,6930,7115,7278,8203,4298,4304,6928,6932,6934,6938,6936,6604,9088,7195,7199,7198,7162,7191,8825,1730,6596,5961,4292,9067,4259,2084,8168,6491,8387,8582,8352,6967,6966,4614,6970,7966,6965,6415,6968,1557,6272,6385,14,6450,3380,8831,3247,5882,8490,4501,7816,6396,6656,6383,6076,7904,8232,1663,8821,9631,1616,3358,7632,9767,6787,8542,8267,6743,3036,6937,6933,6931,857,6545,8984,2594,2005,9488,2005,858,6922,6934,6938,6744,2276,6912,2275,7134,8725,2274,9111,9891,8881,9190,8340,8882,990,6757,6936,6758,6746,6426,10328,10329,9149,6422,6523,6381,9386,524,10098,10961,6929,7971,7576,8981,6926,6933,6650,8879,6742,7703,6744,6936,8700,7104,7646,397,6144,7150,7297,9174,6743,7099,8980,7122,8982,2856,6749,6349,6751,1730,8983,6750,546,9500,2992,4178,4340,5763,6703,752,3457,4023,6809,585,3908,5764,6740,6104,3913,4950,3474,504,7238,3715,1016,3368,3933,7937,7903,8220,4337,4901,4901,6821,8306,8306,8306,6151,8228,6750,6521,6521,6521,3612,7614,7614,7705,7199,7195,9165,7162,7198,653,3875,7196,7191,7194,8988,6385,8984,9592,2520,7199,6925,7200,9087,6926,6931,3277,7190,6386,8986,9172,9885,7199,9177,8986,10044,9175,7196,10045,6931,7192,6936,6759,6762,10649,10417,10487,10488,10813,6754,860,10431,10390,10388,6761,6760,10382,10387,10386,857,6913,7162,6840,6926,6925,9735,10445,6381,6391,6914,6763,6915,9165,8693,8156,8267,7200,7199,7196,7198,7194,10996,10797,7195,6917,6988,6922,8267,10599,10600,10598,9087,10505,11077,10445,11078,11079,11080,10603,11075,6916,6933,6936,11077,3277,6928,6929,6934,7190,7191,7192,6937,6918,6385,673,9178,10597,10593,6421,6423,6920,7042,6424,6425,11103,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10423,10425,8987,6491,6417,6517,7026,7388,7388,7388,10235,6925,6926,6922,4227,3840,9899,653,10339,4419,10169,11284,11299,858,11238,4226,11410,857,8389,9767,3327,8596) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC