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,7113,6122,5995,7083,7071,7096,7121,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,6204,4146,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,6188,5995,6315,1586,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,6,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,2737,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,4544,7823,1257,2677,4519,8901,1537,418,7096,7268,7121,7125,7084,7288,6751,6750,6517,6076,6377,6742,6743,382,7278,7278,7287,7287,6151,6604,6742,388,6918,1557,6745,379,7123,7123,7123,3889,7264,7971,7971,3890,7107,7647,7245,6540,6970,7282,217,7100,8055,7649,1666,8641,8050,8047,9229,7304,9797,7124,7099,7150,7150,7150,7105,7104,9796,7155,9794,5121,6766,6766,2027,5936,1664,3702,4769,7897,7897,7897,7897,2117,6870,7897,7898,7898,6880,3531,7890,6843,8222,7272,7119,7261,7281,7072,7112,7112,7392,7444,7539,7092,7506,7286,7286,7286,7286,7243,249,7119,7265,7273,7085,7271,7077,7655,7252,7661,7662,3561,5995,5719,8537,7095,7115,7270,7247,7100,7074,7153,7119,1198,2995,7152,3392,6659,4519,7102,7109,1533,5777,1145,7243,956,7092,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,7092,8645,431,6771,244,8398,9573,9039,9939,9630,8080,409,1740,7263,7116,7278,7108,7092,7093,7084,7276,7282,7290,7247,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,7082,8425,8400,7292,7088,7241,7280,7971,7092,8401,7943,7280,8201,6400,2000,3913,7113,7109,6490,1667,7076,7075,7271,7271,3090,7082,7072,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,7092,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,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,7265,7250,7674,7271,7093,7666,8041,8049,7077,7077,8071,8071,7264,7264,7108,8211,8044,7084,7084,8396,8537,7095,8397,8067,8069,8069,8642,8285,8285,8282,8282,8282,8282,8637,7241,8368,8770,8047,7287,7906,8419,8058,7101,7101,7660,7660,7660,7096,7071,9187,8087,8087,8087,8087,8908,8908,9574,7280,7657,8475,9293,9293,9158,1366,7445,7111,7674,3860,6644,7112,8040,8082,7069,7069,8407,8407,1666,1265,8268,8268,7661,7501,7501,323,9856,7385,7385,7385,10077,9897,2520,7263,7125,7097,7106,7276,7249,7095,7119,1302,7117,7123,7101,8053,7241,8048,8047,7936,8057,8055,7102,7096,7943,7574,8041,7243,8062,8045,7245,7068,7116,7659,8368,8040,8040,8202,8202,8202,8071,8429,9158,7110,7112,7668,7672,7241,7656,8269,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,275,6743,6390,4659,6133,6821,1167,2263,6633,6209,6240,5566,3425,3896,5883,860,6382,6749,1970,6907,6904,5822,3882,3883,3891,7293,7270,3884,7124,3888,3888,3892,7124,7251,7292,3890,7094,1366,6493,7155,3891,7095,3893,7083,3889,7087,7072,7100,7122,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,3892,4724,6821,7277,7251,8197,7986,7247,8393,1626,7088,8384,8449,8384,7663,8439,8577,8085,8386,8206,8205,8401,7940,3895,8646,8412,8772,8080,8240,8368,8274,7649,7653,8737,4805,6209,9056,7713,3881,3883,4220,8269,5454,8468,7671,9053,6863,8461,4233,8271,4209,9132,9402,458,5484,3894,4519,8893,4800,7985,9481,5777,4690,450,1569,9322,8257,9418,3244,9915,9934,8268,8644,7108,9417,9793,9367,8229,10078,5484,8398,7101,7102,7085,7085,7247,8087,8081,7069,8041,8041,8368,7086,7086,8282,8282,358,808,7286,8069,8063,8063,8288,8213,8213,8569,8569,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7072,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7263,7675,7675,8049,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,7250,7081,7096,8070,7069,7068,7273,9021,7085,7077,9195,8058,7660,8069,217,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7155,7246,7083,8739,585,6870,7149,7069,7088,7121,3493,1516,7280,7243,7115,7152,7094,6263,7086,7273,1589,7099,7105,7114,2117,8040,7092,8097,8079,7931,7244,7100,8041,7654,7268,7288,7082,7125,8468,8212,7245,8394,8268,8547,6740,8063,6264,8063,1499,8306,5402,5331,7068,7245,8049,8470,8055,7115,7104,7112,7069,7094,7666,8287,8365,8450,8417,8050,7115,7111,7288,8084,7096,8047,8743,8212,8406,8736,8644,7715,6593,4438,3865,1302,3337,6183,7666,7664,7092,7100,7268,6798,6548,7245,7112,1173,6715,6102,2417,8044,6127,7074,3248,2342,374,385,7085,8205,7271,7123,8198,8469,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,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,7112,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,8517,1029,8306,6785,8151,7143,2729,8721,4983,8389,6155,7287,7285,8399,8206,8447,8446,7268,8444,7766,7672,8425,7668,6123,6633,7112,8361,8141,8050,7273,9297,7835,9422,7834,8362,8639,36,8741,8200,8055,9543,9275,7261,7096,7287,8640,8207,7245,7574,8059,7984,7941,7939,7940,7943,8061,8066,8253,9719,8475,7666,8643,8419,8202,8722,8427,10056,9444,7085,7249,8469,8086,8792,10008,9959,8431,8426,10089,10090,8468,10087,7585,10190,6821,6205,6907,8071,8741,8737,9658,6133,10002,7792,10088,10808,10815,126,10786,10777,9199,10855,10864,10836,10870,10876,10875,10807,7008,7785,3440,11095,11131,10583,10584,10494,10011,10854,8480,7069,7287,8841,8047,7286,8230,8229,7655,8410,7084,8406,8888,1765,1769,6642,7661,7661,7756,524,7903,7903,7903,7903,7085,7125,7081,7928,1089,8933,7246,8071,8468,8446,8050,28,28,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,9611,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,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,8816,8966,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,2590,5322,566,6130,2677,4452,2615,3908,215,6255,1370,6633,7113,5188,6119,7095,7117,6175,6310,6103,409,524,7295,7082,7238,7023,5995,979,5066,2261,2520,2522,4614,6701,1746,5331,6740,2605,5386,1016,6957,6702,6957,867,7646,7118,7649,1411,3609,3698,810,7076,7081,7116,5763,7106,7109,7087,4390,7153,7114,1165,7653,7599,5297,1685,7122,6272,1266,6623,8080,8042,7291,7269,7285,7101,6709,7096,3550,7808,5332,3754,7932,8049,7643,8281,8077,7245,7931,7906,8444,7967,7605,8541,8552,8304,8480,7658,8088,8435,7903,8542,2389,8283,7154,8721,6870,7284,8706,8389,8266,5371,8628,7068,6359,6890,8290,7262,7124,7294,7289,6656,2521,3644,3359,7110,8207,7661,7675,6332,6855,3725,7276,7248,3014,427,8306,7282,7084,7249,7019,7761,8222,8793,7280,9195,4659,735,7283,6364,7094,9338,7247,1998,4185,7254,7293,7671,8047,8284,8064,8079,8052,8053,8063,6381,9552,9137,8578,9149,8434,3380,6263,1685,1266,8459,8449,8580,8824,8972,4555,180,7904,9743,9793,1257,7588,7721,9614,9800,9888,9868,8166,9959,7239,8581,9931,9933,9030,9386,8725,4639,9936,9950,9349,8922,223,10040,9951,9973,8566,10026,10088,9547,10087,7704,9879,9989,9536,10086,9534,10239,8202,10089,10090,10265,10008,10260,10257,10292,10247,1645,10237,10044,9892,8087,9785,10362,10321,10061,10272,9824,5053,5056,5052,5056,10320,10520,10526,6656,10574,10575,10574,10212,10297,10505,10650,7816,10229,6977,10211,10176,8780,5064,10222,10811,7910,10814,4765,4535,10302,10546,10913,10546,10965,10821,10938,10914,10827,10131,11027,7815,10512,10011,11072,10113,11121,10114,6898,7206,6240,10881,10519,10839,10840,1559,4217,4624,5148,3989,254,5516,585,6250,4220,3613,6255,1498,1439,2954,1073,1954,4005,1830,6117,5764,6635,3904,4046,4128,3368,6155,1113,1163,1681,1690,2915,1038,4050,4049,4045,4233,7262,7244,8206,7263,8206,7263,7661,7662,8063,8087,7099,7068,7284,7282,7264,7286,7288,7106,7268,4209,6863,7984,7654,450,7072,3913,7654,8644,7241,6364,6364,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,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,7079,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,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,8580,7971,7971,9091,8087,8087,8087,8381,7258,8211,6605,793,2573,5848,4788,6560,320,947,4199,6130,1453,1521,6117,1038,1086,4337,6776,2447,6700,3184,7374,4510,4987,2384,5439,226,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,8556,7292,539,6689,7069,8047,7878,4399,7840,7169,9052,8547,9366,9362,9746,7112,766,9552,9796,8071,10048,10056,7019,3159,7953,9833,9945,8514,10146,10130,9116,10836,8556,9563,10906,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,7656,7657,7931,8220,8268,8268,7984,7946,8398,8418,9574,9574,7932,7932,9148,8064,8391,8391,10023,8282,8066,8066,8062,6402,6484,6613,7725,6599,840,6367,6004,7708,9386,7105,9359,9986,6367,7646,7217,1785,9618,10060,7251,7743,7505,7723,9539,7097,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9819,9741,7118,9795,8381,9719,9259,8709,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7646,9053,7297,7119,7096,9564,222,2387,3625,4362,1257,6104,223,5995,7083,7078,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6609,6609,6616,6603,6603,6603,7655,8251,10406,9793,7715,8791,8646,8412,9441,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,9354,9629,9630,7674,8770,7946,8044,7940,7265,8835,10588,9053,7971,8081,8722,8394,8411,8402,10675,7085,7080,9755,9225,8720,7086,8735,8055,3029,8368,7096,8473,9160,7071,9187,8056,3890,7385,7258,7939,10670,10659,11224,8282,9398,7251,10869,8783) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC