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,6130,3702,7832,3029,7906,2753,7160,6588,6157,6177,5420,4140,5908,7144,7088,8041,6740,6641,2029,7276,8384,582,6633,8082,6118,6349,7238,1516,7941,5582,7101,8049,6780,5884,7911,9139,7589,8305,6141,7634,7929,9610,8947,8628,9235,9031,5908,9610,9563,9510,8268,7660,9608,8438,8202,7659,9158,9609,9819,9818,7655,8408,9457,8475,8050,28,28,7089,8211,7666,8055,8055,7106,389,8460,7261,8084,7266,7075,7241,7246,7713,7151,7665,7100,8395,7094,8065,7273,7096,4178,7109,7268,7268,7080,7654,7654,8034,7076,8438,9620,9745,8401,9622,9746,9621,9748,9744,9719,9259,9675,9980,8358,5484,5602,5995,9258,8047,6539,681,10024,8450,9874,9956,9877,5053,9957,9876,3380,9148,7150,8450,7266,5995,840,4146,5419,1768,9820,9933,9933,3874,3874,5064,5064,5056,10272,4146,2253,2253,8449,8449,10024,9999,9878,9844,9747,8071,5376,5376,4512,7238,11225,11225,7110,4349,10022,1770,10212,3165,11452,9574,8087,2658,4395,3863,8524,11438,7243,7074,7092,6190,7280,7269,1242,7122,7113,7574,7091,7118,7109,8087,8909,7085,7572,7095,7666,7252,8401,7241,8213,8080,7245,7281,7246,8384,7654,8452,8909,7251,8362,8208,7713,7243,8772,8736,8736,9133,7714,8782,9132,9622,9747,8395,9620,9621,8768,9610,9058,9059,8419,8087,8085,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,7304,5996,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7715,7287,7715,6940,8450,8240,7938,8362,7671,5262,7243,1126,8644,7906,7072,2033,8469,8852,8891,7109,3882,8891,7270,3892,8438,7270,3893,7294,8365,8769,7266,8724,8576,215,8569,8530,3890,8285,3989,8359,501,7959,8240,8798,8208,5070,5148,8470,5995,7935,3830,7638,8400,2951,735,8236,7125,7096,8641,8227,8050,8407,8396,8364,8396,8364,7265,4131,8422,7265,8422,4580,7297,8042,547,7115,547,7115,8085,9204,8771,7105,8792,1349,7675,8772,7354,8772,7354,9315,6315,8909,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,7155,5995,7155,5995,7155,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,7105,2992,7076,7122,8782,8382,8371,8768,8768,7261,9610,7261,7286,9608,9793,9793,9743,7714,7714,8228,8449,8450,9560,8782,8782,10026,9950,9573,8363,8363,10022,10022,7671,10292,10292,7116,7115,7077,7261,7278,7101,7288,7268,7574,7984,8067,8069,8070,8050,8211,8064,8081,8053,7668,8061,8085,2992,8051,7657,7657,8082,7287,7287,3860,3860,7304,8448,7672,7650,7286,8066,7903,7903,7659,7108,7941,7143,8268,8473,8055,7108,8370,8370,9139,9140,9140,9158,9158,8229,8741,9058,9059,9059,8384,7672,8573,8573,8202,8202,9610,9610,9608,8475,8580,8722,8722,9204,7114,8083,9679,6688,9749,9383,8945,9665,9676,9748,9744,7241,8425,8450,6806,9933,7815,7247,6898,9821,8409,8438,9353,8760,9607,1110,802,9957,9453,9577,10065,772,743,141,9133,9621,9813,9372,9259,8240,9302,9878,7920,7935,8412,7281,7051,9622,9132,9563,5821,5756,9402,9910,2294,9937,4056,608,5545,5339,9205,3080,2933,10405,10209,8207,1699,10374,8999,10373,10376,7839,8450,8451,10343,9352,8782,6852,9530,10623,7665,10568,10534,10109,8240,9747,10642,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,834,8229,9609,8832,3510,2473,2530,5576,6583,1207,6656,3385,3384,8693,8694,7599,4784,1967,4714,7187,5046,8665,1685,9137,3037,8071,7273,7660,8429,8034,10007,9795,9563,9873,7280,7278,8709,9225,8386,7674,8909,7265,9053,7272,7278,9610,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,10201,9892,7287,8203,10922,10044,8326,7269,7546,10275,8334,8358,545,525,1730,8451,1557,9225,3895,8201,8229,10920,3888,6146,9536,730,11336,10853,542,11571,8305,7280,10799,11468,5188,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,8365,7642,9451,9843,9796,9846,8266,9995,9972,9665,9129,3071,9842,9350,9855,8203,314,9806,8228,7105,7104,7107,7103,6689,9854,9867,7155,9794,9580,9498,7070,9632,10238,10053,6242,9880,9622,9205,10176,7120,9563,10254,8450,10256,10095,4121,9134,8732,9621,1768,10232,9259,1616,9204,10077,7632,9539,8047,3358,10037,9933,7121,6898,6272,7111,3889,7125,5769,9529,6613,6582,8048,6579,7256,5051,8965,7119,9084,9578,8201,7152,7117,7116,8739,8053,993,9975,10510,10571,7895,9563,7675,10239,10544,10590,10612,10640,512,7087,10587,10659,10690,510,8824,10592,8770,9054,8644,9134,9563,9055,10586,8053,9055,9134,7088,7096,7086,8055,7106,7083,8034,7297,11212,11189,7243,8240,9622,11187,9746,11188,11196,7298,8499,9206,10588,9563,9620,8407,10272,10692,8438,8404,8208,10614,11150,8928,8236,10615,10689,10587,8410,9813,10869,7122,11108,8782,9609,9608,7668,7669,10565,10328,10975,9610,7247,7672,11096,8573,9748,2913,9390,10537,10060,5267,10547,10767,9135,10505,6364,9370,104,10891,9926,10706,7273,6591,5913,6103,9609,958,9608,9546,8358,10814,9510,10887,8578,10704,1487,7669,10694,11332,8048,9954,8467,11187,10011,9955,10881,9610,8048,11124,9509,11125,8410,10401,10623,8199,11514,10078,8471,8407,11411,9793,6690,9056,7289,11196,9573,11539,7271,8422,8472,7268,7296,11692,11712,11671,11693,10357,8419,11096,10863,11225,9659,11763,9581,8285,11631,10629,7656,9561,9204,11754,10409,9141,8400,9187,11500,10275,9134,8426,11065,10807,11767,10030,11262,8709,7674,11711,9821,11686,11713,7241,11538,11335,9561,11926) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC