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,6388,374,7704,858,1557,857,6373,6382,1711,389,386,8731,9156,6391,673,2701,275,6418,6418,1711,1711,7040,8654,7198,6763,8881,8989,9088,9172,9173,857,1665,9782,9968,730,730,9176,9176,9177,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,240,9411,9151,8987,9192,9767,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,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,9172,9885,7199,9177,10044,9175,7196,10045,6931,7192,6936,6935,7304,6967,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,377,6066,8576,8568,2635,2635,553,544,1462,1462,7680,6763,3449,5718,5718,6381,9189,8082,8443,8253,9312,7090,7090,7278,9300,9864,8995,7266,10056,9573,7585,7585,9304,9560,9560,9577,9577,8542,8542,8542,10265,8168,6925,10026,8782,10572,10272,4080,9148,9561,10836,9076,8451,9949,381,8272,3883,10167,6742,6744,6751,6745,8982,8983,6749,6750,8879,8980,8981,6746,10045,10222,6386,6743,6914,1662,554,10272,9189,9076,390,9518,9520,9517,9521,9522,8985,9515,10429,6854,7703,8987,10427,10647,9144,10729,10763,10532,10763,10126,9580,10532,7238,9192,9191,9217,9231,9143,10957,9144,1016,1016) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC