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,5995,392,388,384,4765,391,392,377,389,5380,390,3875,7837,7834,7835,7835,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,7871,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6379,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9181,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,391,6066,384,377,6082,382,374,544,573,528,539,548,525,549,272,527,6381,6066,393,386,6082,6742,6796,6204,6220,6533,4146,372,375,673,6750,6751,6744,6749,6745,365,6270,387,378,376,389,6076,368,388,388,391,6066,384,386,6082,6082,390,6750,6751,6751,3220,3220,3223,3224,3225,3227,863,3882,6197,7126,1521,8514,8584,6117,8548,228,3889,8629,5545,8699,5339,8248,7697,7616,8777,8682,3892,8795,8247,6124,3515,8845,8599,8819,1698,8583,7693,8615,5807,8596,8323,8932,8318,4613,8999,8242,3139,2807,8224,2786,1299,1765,7839,8010,5013,4460,9197,8904,8978,9200,1349,2393,3376,8934,8935,6703,9348,5222,3080,9289,9122,9402,9347,4023,2393,5210,9476,4277,4800,4538,181,5222,9541,9638,9347,9249,9654,8016,9750,9725,7860,9779,8776,1807,3883,531,3892,7045,6303,545,524,8338,8342,8247,528,3220,6270,539,1198,553,544,551,526,392,385,6523,377,6270,6750,372,545,374,374,544,531,551,2520,3890,3890,3891,3891,8877,385,387,391,6391,3884,6493,3896,3895,3888,3894,3882,3888,3883,3891,6066,6379,6854,389,8877,372,390,380,6376,8329,8324,8323,8325,8243,6377,8882,393,8878,388,6517,8596,9181,8883,8324,8788,6371,6000,385,7067,7067,3840,375,380,8880,8787,8881,8771,8771,8939,8882,8832,8832,374,8878,6270,6066,393,9076,390,389,8877,8878,379,372,372,8598,8317,8336,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,8387,7610,7697,7694,7695,7696,3442,7608,3515,8244,1665,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,379,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,8491,7733,6270,6223,6197,6218,9288,9149,3889,3891,3892,2331,5947,1967,6526,7599,6788,7808,8340,7194,6386,7196,6191,9111,8599,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9425,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,9181,6139,9500,9183,9535,6371,9590,9591,8333,3883,9588,3891,3882,3884,3892,3881,6526,3890,3896,3893,9587,3894,8168,8597,8323,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4291,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,8290,8833,9704,8833,9704,8833,9704,8833,9704,8833,9704,385,8882,380,8878,378,8329,6204,6517,1668,382,393,379,8858,8788,9767,389,3227,7588,372,375,8435,9882,384,390,386,8542,7388,9899,10054,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,9535,10200,10139,10201,10197,10215,1768,8387,380,10199,375,7188,394,372,376,10217,176,9430,10322,9181,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,8588,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,8618,9084,8585,7870,7631,8584,8948,7808,10265,1685,5297,5386,6216,6497,8566,10433,8729,7024,8729,8584,8788,10056,10522,7721,8728,10520,4390,9909,8922,551,9767,10502,8584,7870,6198,9522,1266,9521,6042,9515,9517,550,10637,10794,10793,10639,10791,10646,10790,9192,10725,6066,6536,6537,6538,10557,10199,6534,6505,385,6535,10559,6532,6506,4714,7610,6533,367,7311,10562,7697,6701,380,8323,368,3890,3889,3895,3883,3884,8878,7171,4798,735,7174,7172,7170,8880,10176,3442,7173,7677,8588,380,9624,6197,8154,730,10321,810,4390,8824,7808) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC