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,7262,1886,324,7209,4659,1327,1084,4362,8434,7971,8541,8408,6658,7975,7928,8290,1887,8435,8706,8737,8742,8363,7143,2775,7961,5244,6850,3440,7747,8922,8628,8141,7580,7751,7881,7973,7972,7293,8088,2389,3559,507,7992,7300,7085,8206,7753,7106,7660,7656,7238,8220,8222,5995,1257,4178,4947,446,1215,7977,8290,8434,8435,2520,8174,6642,8175,8306,8628,8703,8628,8703,4598,4599,4600,7928,8737,7928,8737,8737,8793,8681,8761,8698,6958,508,4801,2092,7852,2117,5602,3531,8706,7998,7999,7137,7551,9037,9030,8922,9038,2555,8739,8850,8822,1662,4218,8613,8781,9134,9141,9142,9139,7659,1511,931,9090,186,8721,8053,2712,7117,8742,8231,9300,9079,8019,1145,9349,1145,8213,8044,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,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,10811,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,7252,6578,6658,8412,8412,2635,2635,2635,2635,2635,4683,7906,8283,5782,7079,7079,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,842,8430,7089,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,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,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,7089,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,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,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,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,7837,6210,6139,271,7928,7835,8292,8441,1886,8435,1385,1385,1385,8367,8434,8542,8542,8766,8767,8767,8064,2555,3402,8761,508,842,2302,9349,4720,9072,8517,1029,8306,6785,8151,7143,2729,8721,4983,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,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,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,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,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,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,4544,7823,1257,2677,4519,8901,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,7238,8220,3913,8834,3610,8434,3531,1645,546,7834,7837,7835,7834,7836,7281,7106,4659,8441,8441,8441,8547,8435,6008,915,8052,9161,8206,8737,9199,9199,8741,9614,1016,9572,8657,9577,8052,7095,9658,7106,8874,8325,9183,8340,8324,8883,8323,8313,8322,6223,8728,8337,8598,842,8281,2023,7602,1349,6223,8627,1887,2787,7365,2384,7168,7503,6443,7551,1029,6212,1982,9387,6488,2820,8560,2786,8496,24,7773,1369,6584,6402,6069,1272,9376,8689,9405,6715,1885,5995,801,156,3236,7869,5795,3525,4913,5639,6311,9788,9497,9857,9951,4156,2453,9959,9778,9543,9637,9543,9637,9868,6010,9868,6010,9868,6010,5269,754,5269,754,3878,6173,7437,9090,8497,7388,7390,4316,4512,7422,2520,6715,8290,1970,9361,6700,6383,7493,7521,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,1586,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,6388,8434,8349,5719,8130,8541,8628,8678,8761,7905,8542,6787,8922,9090,1886,8290,8220,8435,9547,8435,9547,8435,9547,6105,9727,8349,6794,6391,8314,8245,8350,8316,2474,8317,8320,8315,6965,6396,8246,8249,8334,8243,6512,1726,8244,8319,8331,8335,6512,8356,6393,6939,8351,6807,7546,6967,6510,8357,6383,8354,6174,6961,3248,6607,1738,6527,8884,6966,6984,7964,6221,6511,8336,9159,8245,8328,9112,9119,6497,6216,9052,9145,6110,3076,6396,6965,8349,6962,9113,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,1662,6787,8290,7027,1884,9507,3169,9547,9374,9090,9386,8435,8196,9729,9497,6520,9713,6171,6533,1770,1766,5692,1767,6263,1770,5743,124,9482,9868,9668,6538,4337,9296,4432,7218,6740,7828,8145,9382,3169,3532,9392,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,1044,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,8926,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,8962,9011,8289,4906,8102,10170,11361,11690,10622,11742,11101,11402,6134,10667,7160,8580,9547,9755,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,1307,7966,18,9046,2384,2889,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112,9014,9366,9281,9547,9879,2627,6836,4558,8764,8434,8856,1511,9737,8956,6294,6740,8111,7238,9692,8220,9843,8220,9843,9698,9698,3879,3893,3883,3882,3897,3883,9342,3949,10554,510,512,1126,1145,2331,4432,5996,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,4984,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,10102,10110,1593,6740,10098,10107,8305,6212,10269,7869,2164,4788,9675,1425,5218,2776,9676,10054,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,8000,1098,4830,4348,1318,1593,3645,3797,5218,5170,89,4008,4164,1561,28,9655,4348,1474,744,9418,11409,10278,11402,1092,11228,4165,470,11252,1092,4984,1198,4940,9378,4943,11546,8995,9838,11610,2824,2785,2778,6443,5306,2904,6962,661,5306,2904,7751,11663,11657,1237,11546,566,4165,3645,2760,1600,467,11485,956,57,9533,10278,11228,11812,3370,3136,1593,1474,1318,1092,744,470,4164,8000,4008,3797,3645,1593,9727,9546,2137,1173,9271,9962,9888,9403,9771,8831,6806,9872,6831,8520,8815,7970,9884,122,9898,5635,4386,9790,9835,2761,10181,8814,8730,4512,2024,10236,6839,8826,7824,7820,9786,5917,9883,9967,9202,10182,9612,9736,9959,9868,2168,6850,8541,9767,9310,9627,9117,5371,389,3073,6354,3070,6689,7753,8088,7752,8822,2999,8172,5363,8627,9037,3071,8780,10519,9870,8515,9496,10685,9391,11074,10868,10552,9168,10041,9295,10672,10673,4510,5872,10961,11073,7130,9838,8972,9215,9378,9810,130,10313,10089,9828,8514,9884,10398,9257,10656,9782,8780,10658,8620,10088,10176,9767,8,8168,10466,7501,8489,9031,2506,9985,7869,1049,10742,10033,386,6270,8881,8880,10098,381,11121,384,3894,3895,3897,8607,11098,11239,8290,7986,11301,3888,7987,11022,3892,3891,3889,11295,3890,3884,11299,6261,8272,3883,4300,4292,4294,4298,4301,4305,1770,4293,1765,1767,1768,1769,1766,11319,3881,3882,11317,6520,368,11392,9547,8434,8435,10578,10310,10836,10040,1970,7998,10038,8542,10036,10166,9968,51,8434,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,10176,10098,3073,10175,3071,8583,9880,4714,6689,9679,3070,1266,8727,2506,272,6198,5810,9824,7881,7752,10053,9665,8899,8897,10067,8896,6200,9867,9031,8489,6215,8668,1766,4842,4286,6218,4297,6216,2794,2791,6497,2789,3071,6880,675,2786,2785,2787,3465,2783,2781,2779,2780,2782,6443,7868,4304,4293,10258,2778,979,7311,10238,9473,10251,9669,4224,2951,1970,6679,9477,10188,3385,6002,8233,9073,9243,9478,545,8714,9383,9476,529,40,10055,3358,10294,9483,5207,1690,7185,7184,8815,4223,9632,3525,1369,138,7178,7179,7632,7189,4386,7176,9921,9637,1137,7187,6198,6362,1325,10258,10398,6382,10608,3875,7837,7834,9376,10607,7835,4931,3254,10552,7836,9297,10467,10536,1557,10568,10232,4,510,9474,7771,7770,6688,511,512,7637,9626,867,9067,9625,9670,9671,10612,8729,9475,8881,8161,10364,9624,10626,8882,8878,10642,10647,10639,10643,9880,9625,8880,10644,7569,7762,4804,7567,7570,7764,10298,9493,7698,10641,8016,10640,9906,9907,9970,10043,10253,10255,10256,10637,10646,10254,10752,10531,7300,10645,3165,10521,10753,10548,2261,6855,222,10522,1520,1917,3059,1461,3595,3493,145,8306,4178,5995,10212,11105,6710,7019,6876,7761,11032,8222,8793,11031,9195,9552,9925,10229,11106,9661,10397,10315,8965,9675,9655,3874,4923,4146,3409,7172,3511,10749,10938,9993,10544,11033,7753,8627,11109,8088,8946,8945,10927,8944,8668,6263,10975,11121,10641,3236,9933,7810,8110,10239,10821,10822,10931,10930,10840,10639,10637,5066,8943,10748,10926,10928,10797,4923,11255,11252,11254,11251,7592,7554,7754,7755,7756,7927,10564,8509,11246,6740,40,6683,145,9635,5,173,8978,10207,11217,11240,9363,6639,4023,6732,2843,5431,8220,9300,7238,7912,11325,7849,10056,10836,1368,28,6598,10637,848,7580,1769,1766,1768,145,8175,1765,10893,1983,7304,11101,11395,9072,11397,3327,11398,11401,9543,11382,30,152,801,9,11383,1230,9352,11381,11328,11431,11421,11171,10057,7356,6773,11396,6792,10687,4510,4752,1973,10788,11442,5363,122,10827,6359,1411,9466,11479,11473,11476,11359,10829,11478,11480,11468,10278,3014,6727,5513,11177,11477,6692,11416,10520,9149,8154,8002,11067,11071,9322,11517,11181,11550,8904,9677,11342,9378,10350,8688,11598,11552,4329,11175,947,4103,7026,7388,7388,7388,10235,6925,6926,6922,4227,3840,9899,653,10339,4419,10169,11284,11299,6935,858,11238,4226,11410,857,9767,3327,8596,8434,11321,11677,8542,11723,11320,9520,11354,6600,11667,11601) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC