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,6866,6542,2520,5371,2261,6869,1769,6840,6869,6628,6754,857,1516,1245,1616,2696,6804,4426,7020,7082,7095,7121,7097,4490,958,7085,7093,6813,1165,6118,4128,6130,5893,6157,5070,4659,1381,1402,6103,5542,2137,675,1016,1038,946,5331,1954,6779,2032,2677,1385,5247,6642,1439,6364,4985,3908,6986,7101,5764,7097,4898,5142,7074,7075,1461,1145,6118,7298,7019,4424,7261,7289,7239,7267,7273,7271,7285,5961,501,7158,7272,7208,7036,359,4079,7296,6740,7605,7579,7797,7245,7089,2674,7269,7097,7906,7937,2976,7835,8093,7264,8041,8144,8057,5764,7287,8169,7266,2046,2389,2025,1461,2389,8187,5142,8052,4563,7939,7154,4624,8293,6740,8423,2381,8411,8237,7982,2261,8258,8305,4639,2658,4766,8480,8483,1298,8417,1917,7994,8079,8459,8853,8062,4395,2913,8894,8769,8426,8810,6891,8955,8306,7037,7761,3346,8763,9083,7957,8651,7659,7239,8201,8658,2882,8547,8736,7210,3261,9308,9261,7775,9160,8055,6589,7900,5455,8736,6792,8055,4131,1029,9277,4597,9561,2052,9580,9038,1453,9647,4983,9562,8477,9446,9754,4079,9834,9444,9344,9136,9313,9258,8046,9367,9544,7073,1272,10009,10027,9450,30,10025,9821,9757,665,9316,9594,9954,9530,9257,8711,10056,10123,10261,10274,10125,10297,10144,8472,8019,8052,9575,9161,10512,10535,10353,10364,10182,9999,10356,10451,9370,9091,10541,10570,10694,10693,9158,9509,7261,10767,10039,10145,9259,10582,11134,11230,8062,10476,11116,9594,11337,11371,11671,11542,11651,11654,11225,10399,11476,11538,10401,10030,11767,9999,11805,10814,10582,11802,11794,11890,11754,9259,8740,8424,7273,7152,7116,7093,5331,7072,6794,5904,6785,2262,6633,186,6139,5996,3860,7304,6845,7991,7210,7223,7243,7074,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,9611,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,7263,7116,7278,7108,7093,7084,7276,7282,7290,7247,7089,7086,7081,7117,7291,7102,7273,7076,7075,7249,7095,7245,7077,7272,7264,7281,7279,7119,7241,7108,7125,7112,7117,7271,7280,7262,7292,7121,7293,8060,7071,7278,7152,7247,8044,8066,7268,7106,8065,8069,7984,8051,8081,8071,7086,7125,7070,7672,7244,8381,8046,7106,7281,8268,7084,8084,7089,7082,8425,8400,7292,7088,7241,7280,7971,8401,7943,7280,8201,2954,6188,4337,4185,4178,4767,1038,4199,5331,5995,446,5020,3026,3904,2054,5286,2262,6821,359,4185,1433,2954,7713,4199,7714,7807,7804,4234,501,5373,1559,5046,6863,4355,7835,7836,7834,7836,2025,7837,3732,7655,7655,7280,8027,8027,8027,8030,8030,6190,7238,7095,7115,7270,7247,7100,7074,7153,7119,1198,2995,7152,3392,6659,4519,7102,7109,1533,5777,1145,7243,956,7089,7266,466,7716,1885,7906,1439,7263,7096,7249,7068,7154,7277,7106,7294,7110,7295,7268,7250,7281,7275,7093,7241,7666,7249,7265,7292,7088,374,7293,7125,7281,8408,8425,7288,8201,8220,7282,8577,8404,6138,7279,7080,2079,7280,8406,8400,6138,7704,8361,7266,1245,7264,6879,9302,7671,8782,7967,8034,8049,9289,4580,8402,8450,9581,9148,9315,9259,8645,7089,431,6771,244,8398,9573,9039,9939,9630,8080,409,1740,6593,4438,3865,1302,3337,6183,7666,7664,7100,7268,6798,6548,7245,7112,1173,6715,6102,2417,8044,6127,7074,3248,2342,374,385,7085,8205,7271,7123,8198,8469,7089,8438,6807,8740,8577,8640,1296,8418,8447,8447,368,6076,8568,8362,8362,7251,7251,8424,6614,8203,7095,8395,8251,6082,7656,8201,8201,7068,8408,8207,8199,8471,8646,8537,8282,9203,8724,8396,7660,5872,5872,7101,8768,7944,7944,7659,9158,9158,9199,8570,8737,8737,9658,8058,8269,8269,10185,10185,10185,10051,10051,8268,7932,9889,7103,7097,10451,10399,10400,10401,10228,7105,9140,7296,7072,4178,5995,5995,1769,1768,1766,5995,5995,2915,2915,8220,8306,8306,3860,3860,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,7094,7155,8063,7246,7281,6832,446,7151,51,6178,8084,7083,8402,8212,7928,8042,7250,8404,8569,4178,8706,8408,7251,8576,8403,8208,8361,8083,8576,7671,8407,8365,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,585,6870,7149,7069,7088,7121,3493,1516,7280,7243,7115,7152,7094,6263,7086,7273,1589,7099,7105,7114,2117,8040,8097,8079,7931,7244,7100,8041,7654,7268,7288,7082,7125,7089,8468,8212,7245,8394,8268,8547,6740,8063,6264,8063,1499,8306,5402,5331,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,5996,7123,7100,7082,7116,7112,7088,7276,7072,1828,1726,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,7272,7089,7119,7261,7281,7072,7112,7112,7392,7444,7539,7506,7286,7286,7286,7286,3254,7120,377,7304,7643,3891,7251,3896,7076,6382,323,3581,1557,6984,3076,6396,6962,8881,5718,7109,8228,8439,546,539,8085,8339,7238,8342,8332,6726,8338,979,7672,8404,3878,7903,730,7143,7546,8615,8586,7870,8584,4432,8460,512,1461,7771,8583,5020,8398,8401,5995,857,7772,8044,8063,1927,5331,1917,1929,7833,3581,8334,7660,1928,7659,1268,4969,3701,3933,5362,6497,2244,5477,1536,7268,3875,4603,8332,4599,542,536,4600,539,5235,4602,6315,8215,529,320,553,3612,8724,3701,544,8275,8946,8343,547,9291,524,9301,9289,9337,4652,7666,7037,1349,8365,9374,8044,9346,8573,739,9248,7270,8805,8934,7913,61,7261,7068,8915,1741,566,1210,1207,7580,7755,5143,5251,7756,8509,28,2677,7554,7927,1511,7279,272,7107,7280,7097,8066,7086,7096,8055,8065,7932,7077,7154,7931,8076,8087,7941,8064,7943,8053,8077,8208,8063,7081,7071,7263,7121,8453,7106,7664,7115,7250,7250,7262,7656,7084,8450,7671,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,7079,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,8426,8077,8418,7271,8472,8396,8067,8419,8368,8086,8712,8427,7285,7085,7280,8741,8206,8658,8282,7102,8711,8794,7931,7097,8740,8567,8891,7114,8742,8892,8052,8079,7655,7281,9058,9059,8206,8891,9091,9140,9158,9160,9056,8467,9157,8045,9204,9205,8059,9247,9261,9148,9225,7248,9302,9262,9264,9313,9141,9138,8415,8768,9368,9367,9401,9443,9445,9400,7931,9529,9530,9133,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,9441,3860,9662,7671,9660,8417,8644,9815,9816,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,7094,7093,7084,9430,9535,9591,2778,2783,2791,8591,9588,1770,8899,1766,9590,6354,8946,2823,3073,3070,3071,2828,2824,6689,7810,6220,6688,6221,9299,7083,8088,8087,7106,8627,9037,8071,9793,8594,4752,10056,7169,8618,9906,9349,9970,10253,9149,1769,9418,8306,4178,9907,8820,1257,1210,10256,7100,151,10254,8683,8816,814,5567,8894,9873,52,5995,5227,7714,9401,4784,4788,10347,5839,8460,3493,675,5516,9601,10342,8716,4639,2261,10255,8953,4788,2467,9389,9387,11669,11046,11030,7635,7913,4765,8205,9655,10672,5459,8408,11732,3878,9390,730,1521,10062,252,9352,7017,9454,9638,6863,2337,4805,5373,5142,4136,3542,585,8888,10116,107,606,188,2918,10009,7249,1894,8930,8473,8056,1650,219,10120,8055,9768,9769,1176,3715,926,8900,7615,7582,7550,8089,6713,8837,7016,5812,5379,7614,10112,9630,3625,9086,8925,3413,8805,8915,8901,8902,1349,9454,9249,8795,10244,8068,9220,9874,9873,9876,9875,9878,9877,9289,9352,9346,4082,7602,9654,7655,8935,10063,10227,9879,10526,9910,8934,9197,4805,10528,10245,9402,4652,10523,8368,10272,162,4209,7903,5729,8890,6251,8800,9900,9817,10115,10699,9993,10229,10246,10341,9248,8804,9464,10548,10894,6876,9081,7019,10856,10895,9363,1461,7761,8222,3595,10904,6710,8793,10569,7155,10858,9195,1520,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,10011,11331,9756,9755,8370,9053,8571,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,11912,11913,11893,11863,11884,7646,11915,11916,11626,11955,11914,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,11380,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10741,10863,7095,10733,10914,10362,10782,10737,11513,10400,3115,3719,9293,6631,7894,11515,10039,11443,6779,10587,9189,11528,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,11380,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,10906,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027,10774,10835,11693,10585,11652,11448,11709,11761,11763,7975,11332,11779,7765,11528,10629,10659,10906,9055,11762,11777,8414,7275,11469,11500,11368,11370,9305,2748,9062,11893,11713,11804,11553,10770,11803,11540,11573,11542,11558,11887,11889,8071,11882,11916,11975,11974,11332,10356,8394) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC