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,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,7089,8212,7245,8394,8268,8547,6740,8063,6264,8063,1499,8306,5402,5331,7646,8034,7714,8409,8439,7716,4224,6259,8240,8423,7247,6270,8393,386,8430,4684,8641,7083,7155,7119,7097,7110,7085,7112,7096,7266,7211,7115,7572,6140,6140,6631,2005,7086,8405,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,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,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,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,9611,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,11836,11516,10427,10963,11674,3359,11889,2780,2786,2781,2778,10789,10930,10931,10232,10926,10927,10928,11067,11068,11878,5134,3287,10543,11697,11981,8945,11576,11574,11694,11723,11355,6768,11877,9625,9626,11575,6506,11354,6533,6532,6535,6505,11355,6538,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,7931,8418,8084,8056,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,1765,1769,6642,7661,7661,7756,524,7903,7903,7903,7903,7085,7089,7125,7081,7928,1089,8933,7246,8071,8446,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,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,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,9017,7602,737,9136,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,7092,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,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,5995,5279,9055,8462,8048,7731,8739,7293,8466,8517,1029,8306,6785,8151,7143,2729,8721,4983,8389,6155,7287,7089,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,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,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7539,7539,7539,7539,7539,7539,7539,7539,7539,7539,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,7388,7388,1307,1307,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8892,10026,9189,8425,8386,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,11711,10400,11711,8425,9057,9508,8462,8928,8081,9286,9995,9441,9560,10449,9082,8444,7113,8459,9998,8794,8438,8207,8571,9370,10030,8740,8424,9530,8427,10007,8086,7080,8063,8426,8720,7574,8205,10888,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,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,7092,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,7271,964,7281,7095,7032,7262,8839,8204,1511,8472,4558,7296,1172,7280,7068,8419,7285,8423,8474,8770,7275,9049,8712,9508,9508,8439,8409,7674,1089,9793,783,8782,8229,9620,7286,9658,9658,9619,7279,10007,10051,10185,9817,9817,8207,9956,6778,6778,10272,9819,9577,9813,9957,9562,9510,9818,10271,10401,9053,9312,8237,7285,7289,10407,10888,10891,10843,8929,10302,10789,8395,11058,9873,9794,7879,7657,9312,501,9292,9313,8477,8269,9148,10023,10075,9161,9264,7659,9158,10027,10403,10404,8928,8208,9148,10022,7669,9225,8079,10403,10449,9530,8832,10409,8235,10437,10609,10588,10774,7110,10591,10835,10889,10575,9219,10836,10272,7125,9401,10887,10029,11059,9058,9968,9091,9054,9139,9160,9187,11065,11034,11035,8073,7077,8040,10586,9447,11402,10580,5251,9676,9557,9325,7981,9526,10080,7909,1823,3856,10061,10081,7807,8737,8175,8206,4770,9503,2032,9968,4230,1487,7150,10270,3511,3564,104,3189,10275,9547,3896,10274,8767,8467,10008,10965,8063,10271,7297,8641,7298,8712,8046,9203,10789,8394,7262,10356,10449,8205,8202,11553,11634,9095,11038,11683,11362,9782,10768,9797,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,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,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,10486,10487,11045,11022,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,9744,11335,11841,11866,11839,11840,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,11197,11200,11034,11063,10787,10820,4901,10914,1576,11201,11347,11324,1886,958,11130,11402,11278,11488,11376,11117,10039,10494,10885,11115,10687,2266,11495,11449,11497,11455,4154,4520,11782,8937,8299,8144,8516,1385,11272,11234,10720,9277,11776,11187,11843,11840,7804,7893,11704,10269,9007,9757,10869,10854,7069) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC