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,7115,7906,8063,7068,8712,7085,8048,8368,9083,7080,9053,9148,7244,9057,7944,7287,7287,7111,9259,7282,8404,8713,8044,7152,7671,8080,7935,8460,8709,9398,8652,9225,9225,9560,7279,7279,8364,8364,9755,9225,7080,8408,9199,10030,8364,10023,8363,8232,8232,7266,9956,9302,10076,9999,10024,10024,9956,9956,8229,10046,10278,9421,4624,9980,8782,7654,9813,9878,9755,10577,10768,9794,9561,10767,10769,10869,9316,10833,10854,10757,10855,10770,11038,10675,10890,10854,11210,11210,11262,9739,9875,9874,11335,10623,9873,9873,11225,11514,11331,8205,10572,8063,9739,11692,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,7089,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,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,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,8468,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,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,8468,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,10272,9141,8063,10051,10630,7275,10076,9157,10026,10770,9437,9438,10078,8577,9744,9957,10475,9999,10887,10862,10024,9745,10881,10882,8908,9264,9577,10271,10572,7271,10074,10773,9660,9813,10609,10889,10577,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,9639,8472,10513,11927,11913,11892,9354,9629,9630,11888,11881,11926,11957,12007,12004,10904,11797,10891,11334,10615,10614,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,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,10591,10659,10774,10615,9957,10807,8928,8438,9973,10007,10011,10009,10854,9875,9876,9877,9874,11064,11065,9878,10029,10625,10835,10834,10965,9744,9796,9821,11108,11063,9955,10888,11187,11196,9148,10623,11210,11212,10614,10855,7576,10617,11525,11331,11500,11892,11211,11376,11211,11376,11884,11512,11867,7714,11889,11894,11911,10189,10833,9956,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,11254,11297,7186,11418,9920,11251,7870,7188,10821,6200,9632,4463,11493,7267,10890,7546,11431,10565,11462,11192,8451,7182,11321,11016,10642,10639,11245,11218,7185,11320,10646,11463,10752,11422,9633,11191,11193,10643,10612,10644,7176,7172,11570,11650,11019,1557,11011,11032,11354,11723,11252,8362,735,6596,8200,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801,11125,11926,11712,11525,9232,7669,10807,10889,10647,11893,5484,10292,4510,8303,4784,10039,9258,8949,7376,9007,7806,4557,7218,10000,9649,1016,9441,7505,6547,10768,9866,11373,11661,10687,11385,3582,9603,10836,10056,11402,10707,8517,6870,10187,10702,10010,11776,11400,11214,11399,11749,6978,9865,11328,11472,10010,1793,11711,1151,1772,11756,11805,11806,11777,10410,10411,7368,10449,10965,11332,8202,10406,11629,11628,11767,11866,11653,11634,11884,11839,11553,9508,9821,10891,10768,11844,10399,10400,10401,11794,11630,11893,11864,11778,11793,7632,11459,11460) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC