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,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,7111,7294,7124,2706,1398,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,4801,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,9133,7190,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,10486,10487,11045,11022,7078,7647,7674,6804,7124,850,7647,7083,4362,1266,6359,7390,7150,7286,7293,3884,7083,7281,4752,7124,7297,8051,7256,8059,7265,8070,8084,8206,8425,8425,7283,7283,3647,8359,8359,8425,8765,964,964,8409,52,52,52,7890,8867,3885,3890,7109,7279,7261,7261,7261,7261,8571,9594,7244,7278,7110,7091,7096,7256,226,226,3402,7283,7967,7123,7298,1988,587,587,7114,7916,7083,7241,7241,7895,8064,7112,7254,7254,6127,7074,7093,7574,7069,7272,7665,8065,7674,7094,7266,8055,8753,8456,8201,8080,8050,8087,8385,8064,8769,8635,8736,8439,9560,9578,8407,6984,7671,9148,8363,7642,8417,9314,9259,8767,7304,5996,5576,2869,7261,834,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,9611,8909,9611,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,6162,5996,6159,2992,2473,1666,6869,7150,7081,323,7155,3254,4614,7280,6382,6152,6985,7243,7155,7713,8228,8228,1770,1765,1771,7182,1768,1766,9383,6354,3070,3073,3071,6689,8816,5094,9619,8520,8730,8814,8817,7751,7972,7973,9655,9665,7877,7897,7124,7122,7122,6561,7985,7985,7913,8171,4079,8438,8438,8498,8090,7884,7884,7884,7665,1250,2093,1324,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,1324,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,7097,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,6832,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7993,7804,4339,2027,7715,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,8141,6193,8141,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,7834,7812,7879,7836,7878,3131,3428,6521,7663,7764,7762,5091,7568,3520,7570,7246,7569,1656,8071,1770,7151,6531,7650,7649,4301,4293,4289,4299,4286,4305,4287,4294,4292,7643,4302,7963,4297,4298,2766,800,5024,1085,6103,6780,972,8300,5371,8531,1086,7599,3519,979,7906,8587,7568,6532,4804,8836,8814,1667,6306,8520,9038,8816,6618,9030,8092,801,7808,7278,7278,3893,7100,7155,7252,7252,8362,7261,7096,7654,7654,3895,2992,3895,3888,6588,7649,7819,7116,6364,7740,5996,8372,7121,8373,7094,8373,7265,7265,7100,7118,7118,7088,8379,7105,8375,8050,7287,7106,7702,7654,6382,6382,7675,7094,9132,9579,7006,8203,7094,7104,7068,7070,7124,7107,8212,6740,8085,7292,7292,8471,8471,7286,7261,7261,7150,7150,5053,5053,7643,7643,1126,2520,2520,8200,8200,28,28,28,28,8376,8376,8376,8167,5053,3380,5051,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,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,9611,834,8229,9609,8832,3510,2473,2530,3908,7243,4987,8428,6691,3580,7944,5251,7748,3549,8151,5222,8767,947,4432,8302,4983,4901,5334,6622,156,1591,6553,7102,7095,7088,7110,8082,7653,1981,1981,7254,7113,8430,7674,7277,7574,7895,7288,8385,8472,7589,8464,7147,8047,7106,7767,7765,7092,8645,8742,8269,8374,8381,8072,7931,7932,8475,8477,3874,7646,8641,8640,7286,8363,8067,7068,7279,7108,7068,8366,8456,7071,8573,7672,7941,7941,8394,7252,6578,6658,8389,8412,8412,2635,2635,2635,2635,2635,4683,7906,8283,5782,7714,8071,7713,8577,7280,8087,8034,8067,7944,7246,8371,7243,8381,8080,8198,8240,8240,8240,8199,7113,8197,7975,8083,8205,8742,8742,8460,8580,8413,8413,7654,9719,9742,7150,7499,7291,7975,7122,7154,7107,8033,8228,7247,7654,7100,7967,7155,6718,7298,7906,8205,7106,7103,7251,8361,8580,7297,8208,389,7270,8381,8425,5936,7674,7967,7294,8203,8828,8407,9049,7096,9158,8047,7266,8207,8203,7642,8413,9141,8980,8879,8981,8982,8983,8498,7704,9146,9882,9794,9892,6744,6749,6751,8410,6746,6386,9176,9762,8581,9177,10097,10098,9821,10189,10095,10078,9733,9088,6854,3894,3893,8784,387,392,6082,372,365,8530,8529,8201,6076,9217,4305,10161,5995,7913,10263,10213,8882,8788,8786,8451,8211,7287,8461,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,8386,7082,7109,7075,8412,8208,7294,8052,8767,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,1983,8129,9620,9189,9141,7241,7088,8283,9076,8386,6961,9729,8365,9492,9730,9481,4029,9537,7124,7107,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,9441,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,9817,8767,8203,8085,9083,7715,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11367,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,7110,7096,7971,7280,7244,7288,8055,7112,7084,7655,7078,8050,7674,7932,7932,7932,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,8047,8055,7241,7292,7572,7121,7660,8058,7280,7272,7278,8401,7117,7111,7097,7106,7069,7112,9132,8828,6208,11114,7084,5564,6718,4724,4659,2830,5923,10372,5988,6342,6190,10671,10483,10887,10888,7088,7281,8891,9659,7108,9562,11514,11508,7890,8219,9338,7661,7077,11351,5922,8737,10078,10271,11531,5838,1458,10991,10854,7933,11756,10855,2182,5942,7251,6691,9375,6832,1645,7872,8740,8459,8424,8474,8568,11516,9875,10575,8211,9609,9610,11626,11034,8415,8743,11035,11866,7661,7662,10302,11862,11840,9053,11674,8460,9398,8462) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC