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,7083,7119,7097,7110,7085,7112,7096,7266,7211,7115,7572,6140,6140,6631,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,7281,6413,6414,2389,7387,7066,7594,4544,7421,7672,8203,924,7374,7491,7565,8363,5454,156,8206,8206,8839,6364,7120,7150,7105,7650,7650,7646,7646,7647,7647,7104,7118,7118,7642,7291,7291,7246,7096,7270,3884,3891,7476,6270,378,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,3891,7095,3893,7083,3889,7087,7072,7100,7122,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,7089,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,5897,6799,6804,3744,1270,6727,5068,5998,6977,7149,7374,2967,4985,6565,7416,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,1245,6381,6743,323,6388,5386,388,6656,3515,858,6503,7107,5909,863,7654,7654,7713,7072,7105,7644,7650,6796,380,7020,726,1250,1165,979,8085,4490,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,7094,7092,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,6162,5996,6159,2992,2473,1666,6869,7150,7081,323,3254,4614,7079,7079,7280,6382,6152,6985,7243,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,7278,7278,3893,7100,7252,7252,8362,7261,7096,7079,7654,7654,3895,2992,3895,3888,6588,7070,7277,7967,7153,7666,7986,8287,7247,7297,7297,7297,8228,8412,8412,7649,7107,7150,7104,7150,7118,7120,7297,7099,7105,7107,7246,7103,7298,7151,7118,7083,7107,7094,7650,7671,7298,7297,7671,8240,8450,7649,7715,7650,7654,7291,8961,8269,4224,8645,9032,7935,8048,8064,8430,7115,8450,9189,9148,9132,9132,7671,7671,7666,8240,7105,7272,7107,7121,7288,7282,7282,7120,7967,7272,7275,8363,7032,8240,8474,7298,7298,8395,7671,8384,8736,8386,8386,8771,8034,8083,7112,8792,8443,7574,8033,8253,8047,8082,8040,9259,8048,8443,7147,7110,7110,7110,7110,7082,7783,6270,8203,7070,6396,7253,7252,7254,7083,8580,6750,6381,8771,8832,3604,7252,6076,7032,8665,397,1385,857,8361,858,6823,4769,7118,388,7119,379,820,4989,6381,1557,3897,6270,3893,4452,6600,3884,3894,8034,3889,3891,3892,7117,8047,7693,7975,7100,7654,6272,6195,8050,7096,3881,7304,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,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,7150,7499,7291,7975,7122,7154,7107,8033,8228,7247,7654,7100,7967,6718,7298,7906,8205,7106,7103,7251,8361,8580,7297,8208,389,7270,8381,8425,5936,7674,7967,7294,7079,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,7151,7255,1663,7075,8080,7069,7279,7252,8199,8198,7655,7674,7288,8743,8063,8063,7113,7572,7286,8737,7080,8741,8742,8742,8742,8742,8742,8742,8415,1779,7654,7083,7083,8793,8544,8193,6381,7307,7124,323,7270,6004,6740,7238,8220,2041,6715,7976,7076,8738,6569,182,8541,8922,6843,3647,2331,6700,659,9338,9612,186,8577,8085,9048,9048,7713,8782,9007,7288,7250,7674,8354,7286,8282,8381,7112,8087,8430,8783,7295,8411,7574,7249,8080,7659,7096,8377,8033,8059,8366,8058,7100,8203,8454,7278,8453,7663,7252,7906,8287,7253,7151,7113,8361,8771,7082,8040,8082,7281,8429,7277,8409,8036,7110,7154,8044,7105,7150,8373,7115,3908,9621,9896,7642,7123,8212,9898,7259,9620,9957,9954,4121,9954,9619,9997,9501,6824,10011,10017,368,3784,10013,11394,368,3784,11391,11335,5066,11390,11277,11211,9959,10016,9965,11059,11187,11331,11210,11392,10855,11262,11196,11458,9956,10625,11534,9955,11225,10906,10585,11212,11654,11674,9502,6520,9579,11668,11553,7252,11539,9398,9132,10624,11274,11278,11187,11395,10881,11614,11472,11867,11868,11469,11958,11911,7261,11514,11818,1349,7491,8859,7238,8864,7647,7110,8477,8063,8423,7068,8047,7258,8406,7574,7654,8049,7446,8208,9161,9161,8269,9398,9398,9247,9247,9049,2627,2627,2627,2627,2627,2627,7298,3337,6584,7110,7072,7074,7251,8400,7252,7252,7252,8236,3896,3892,3891,8576,7083,7107,7674,6386,7100,8365,4121,4121,8085,8236,7118,8228,7291,7700,6768,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,8365,7115,7110,8364,7125,7083,7715,7765,7243,8082,9132,9148,8240,7291,7251,7665,8469,7107,7647,6794,9032,9205,7646,9047,9189,8446,8580,9259,9076,4973,7671,8768,8769,7247,7249,9134,8423,8852,9315,8439,8443,8083,7094,8060,7275,7666,8451,8034,7674,8770,8358,2643,7109,7268,9161,7104,8447,9314,7150,9537,7647,9133,9133,9573,9577,9619,9748,9622,9621,9747,9620,9560,9580,9746,9745,9876,9878,8085,9876,9877,9956,9138,7291,9744,9873,6264,5763,1764,7266,7094,7105,4834,7666,7654,5995,8846,389,7910,6175,1215,7665,8939,7593,2995,9116,8358,4639,9202,9280,9300,8085,4983,9386,2897,8231,2085,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,7089,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,7089,7246,7083,8739,8439,8439,8472,7674,384,384,8770,8770,8770,8770,8770,7649,9609,10274,8283,7285,7906,7906,7906,7906,8268,7602,7261,7261,7287,8362,8205,8205,8205,8205,8205,7252,7253,4752,7644,7643,8080,8080,8080,7104,7124,7648,8081,7261,7088,7088,7088,7658,7286,7975,8041,8041,8574,8713,7078,7120,7261,7150,7077,7109,7655,7099,8832,7295,7661,7662,8771,8771,7111,8306,5994,7646,9619,9133,9133,9132,8460,7104,8111,8080,7261,7261,8055,8055,7124,7124,8050,9797,9797,9797,7283,7283,7283,7283,51,9132,947,10858,7094,7105,9878,9877,8087,8206,7661,7662,8410,4774,7077,5923,6870,8828,3066,6691,7077,8371,4146,8820,7654,7654,7647,7665,2473,6726,7076,1371,7605,3896,7986,9132,8666,9542,3913,587,7126,7953,9340,9116,9900,7913,7572,7589,8290,10095,8244,7251,535,8400,553,3874,8832,1766,2727,6656,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,1398,5756,3189,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,1645,8628,8306,8783,8933,8361,3287,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,3549,5334,11213,9039,6785,10579,11439,9897,7849,3169,8050,7261,7261,7264,9148,8770,7262,7264,8462,7097,8460,8034,8034,7121,8445,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,9611,8909,9611,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,5995,5995,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,1537,418,7096,7268,7089,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,9794,9386,9031,2052,7214,4639,9049,9258,3389,6547,6823,8232,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,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,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,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,7092,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,10858,9195,1520,8081,7252,8460,7287,7250,10833,8446,10624,10625,7649,10941,8208,10942,8580,9564,11225,11210,7287,7280,7714,9543,8,7563,9892,9149,6596,11150,3359,8205,8582,10858,7283,3895,8366,10947,8782,10948,4390,186,6768,1411,7024,7280,535,3896,3887,810,10944,9885,9601,8204,3894,1303,10829,3897,3885,3881,10000,10943,9959,9076,7704,8201,11108,7986,8451,51,3085,7245,10827,4639,8712,7753,8228,8240,7752,10077,7147,7572,3070,7589,11225,11063,8272,6688,9095,10053,104,9095,10053,104,9579,11514,8640,10615,10008,8211,9867,10272,10232,10675,7172,10975,4659,11221,9222,9223,8812,9251,8812,9224,10887,7080,7088,10976,7600,11228,10278,9968,3908,11631,10823,10930,9741,8971,6740,7153,11836,11762,7933,7238,9007,11707,7661,6629,1381,9255,8220,11628,10926,9817,7280,11762,11211,7121,10789,9259,7286,11210,7766,11509,8080,8366,11894,11212,7261,10630,8360,9756,9755,11515) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC