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,6381,1766,1506,6617,926,2783,4146,222,6178,1038,600,3841,4411,504,1770,388,1771,323,1767,1730,6742,1768,4156,6664,4452,3036,512,1557,4185,6390,1351,4146,1770,6740,3874,4614,4146,2023,6034,6036,6596,4473,6381,6038,4791,7238,7505,435,5143,1765,6740,7238,3511,3874,508,1771,1767,7834,6740,7238,6482,7473,7837,7836,2786,3874,6023,7837,7138,6639,7354,6730,6684,4146,5535,1215,3511,7837,7834,4146,7089,553,7297,547,7107,535,545,546,547,548,549,3714,2997,7516,524,542,6569,536,536,6100,5914,8372,7102,8055,8055,7083,7270,7270,2873,8408,8832,8832,526,2447,9632,7664,9107,9973,8363,8081,9082,10025,8185,2374,2182,524,952,549,377,3882,3896,382,537,384,6082,393,539,546,548,536,525,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,863,864,6583,6752,6780,397,6883,6493,388,5956,1121,6986,391,6066,384,377,6082,382,374,544,573,528,539,548,525,549,272,6381,6066,393,386,6082,6742,6796,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,863,3882,6197,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,6173,1313,6563,6978,7024,6189,1407,1441,6181,6546,1165,4450,3073,6654,3115,7748,360,444,3041,6732,8118,4986,5635,778,8358,7077,8222,8738,8765,3070,1537,7835,9052,435,8439,7304,6870,8526,8526,8526,8048,10010,10377,10591,10592,10467,10587,10692,9300,8783,7270,3026,7895,1461,7265,7241,7941,7875,7939,7077,8070,8086,3933,6365,7992,2029,7946,7087,8078,7119,7093,7944,7121,7108,7589,8365,7271,7268,2006,320,7677,7096,7083,6241,7071,7241,7095,8611,8688,4355,8404,8049,7281,8615,8819,8422,8227,8407,8404,8375,8908,7286,8049,8793,9027,7080,8084,8918,4209,8938,8561,7674,7117,7270,7096,7940,8460,8362,8641,7266,8438,8767,8447,8709,7108,8641,8836,3904,3830,6197,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,3893,543,528,538,8425,788,2023,7174,551,540,8404,532,6382,546,541,553,545,544,536,533,6493,542,531,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,9048,8716,9076,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,6390,2989,5380,223,1029,5576,7238,7304,6364,2869,6740,961,4294,5297,4395,4293,7593,1272,2605,1461,2706,5386,243,7179,7599,5992,1371,7022,840,1351,7761,1095,4432,7840,1165,7984,6809,1349,4386,7176,8091,4985,4944,8135,7920,4945,4941,4940,4943,4942,4939,675,8358,665,8151,7239,7900,1126,8547,6600,217,8514,501,7241,7187,6953,7261,6570,6644,6104,8825,7665,8783,4834,8626,6595,8142,8488,7910,3029,8781,8305,6499,3549,7636,8019,5121,7994,8638,812,5334,9007,8055,6780,1645,1345,8047,8019,8780,7751,8816,8955,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,2467,8681,9546,9558,9577,9900,6113,9945,9386,10046,9959,10146,10240,9601,10353,10346,10349,10467,10002,9257,258,8269,7659,9277,10060,10892,10814,2399,8471,8092,7900,7283,2913,8955,2761,4765,11272,11271,10287,7874,8033,11333,10715,8530,8908,7655,8065,3885,1766,3882,6354,3073,3071,7751,4512,3070,6689,8244,7752,5298,7752,8241,7072,8246,8311,8682,7636,1368,507,8704,1257,7238,8174,7580,7881,272,8306,446,1215,5995,5732,7837,9037,1165,7835,2023,8598,8840,8319,640,8247,8441,8425,8407,8439,8404,9138,9297,9187,8400,8568,9795,8794,8410,9564,8413,8782,8782,8451,8577,8208,7836,9372,8329,1347,608,1253,4258,9937,7920,10232,10243,8402,10095,8580,9560,10401,8450,9313,8407,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,381,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,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,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,385,8882,380,8878,378,8329,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,9899,10054,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,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,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,9438,8273,6493,379,3897,8878,9014,6831,10039,9799,7037,2122,6806) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC