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,863,5719,397,714,6798,6390,713,6381,3036,6082,386,392,6381,3841,382,323,4906,388,372,6380,374,2701,2474,7238,3860,378,4199,6740,3933,6809,7833,8215,7903,1984,5995,4878,391,6066,384,6082,382,374,544,573,528,539,548,525,549,272,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,381,368,388,388,391,6066,384,386,6082,6082,390,6750,6751,6751,3220,3220,3223,3224,3225,3227,863,3882,6197,1085,4671,6580,6102,5912,6796,6138,2071,867,1044,524,952,549,6204,3882,3896,382,3221,537,384,6082,393,539,546,548,536,525,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,6,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,1955,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,5516,1425,1307,5915,446,4788,2451,5995,5371,1145,1681,1485,5719,6316,375,386,6082,7076,7094,7118,7072,7124,7113,7150,7109,7246,254,1572,1981,6140,5995,392,388,384,4765,391,392,389,5380,381,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,382,385,390,3090,6742,3728,5371,381,386,6076,385,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,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,2261,2522,2992,3888,6493,1070,1520,6710,1768,5331,6740,7238,6644,6644,4597,5215,5215,2658,3465,8220,8220,8271,4218,4218,7928,8886,7985,3894,8836,8836,272,3165,3254,7120,7304,7643,3891,7251,3896,7076,6382,7092,323,3581,1557,6984,3076,6396,6962,8881,5718,7109,8228,8439,8165,7235,7721,650,7001,6565,6076,6544,6669,7230,5996,6122,3879,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,7304,6967,3220,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,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,8986,10026,8782,10572,10272,4080,9148,9561,10836,9076,8451,9949,381,7655,7286,7143,4639,1645,7976,7080,8109,7897,1487,4617,7069,2389,375,390,6066,8078,8078,7279,3647,8230,8512,8611,8306,8306,4570,7910,8991,6907,8282,7084,8948,8459,8740,8469,8765,394,388,8880,8880,6774,7986,7986,8877,6154,6794,5996,3860,391,387,6151,6159,1126,6562,7238,6140,1558,2005,6578,2635,7576,7576,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8163,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,6784,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,1767,501,1769,1768,1766,6740,7238,7160,7985,7987,1005,7840,3892,7840,8725,8903,9030,4784,5066,993,7599,435,381,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,7920,8220,2522,2522,8936,8880,4670,8220,4146,4146,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,8682,3070,186,3073,3071,186,3071,186,6689,6354,186,8727,7753,8727,7753,3070,7752,8088,8627,3073,8814,8817,510,1368,7753,7751,8717,7972,7752,7973,8088,8946,9037,8681,8817,9084,7751,7972,7973,6362,8271,8718,4178,233,2035,245,254,1005,1209,842,1993,7920,7149,8220,8440,8514,8483,8547,6911,3888,3892,9220,9300,9284,9258,9298,2265,9354,8183,9030,2849,2290,6842,5222,5331,6842,8683,737,551,9322) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC