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,6197,6201,4293,4289,4305,4296,4298,4294,4292,4290,6200,9631,7963,4300,9633,4286,7610,7696,3442,1704,3515,7608,4087,4766,7719,9383,10245,9867,11268,93,4730,6545,6371,7082,5245,7666,5245,7100,8724,7665,389,7632,9493,9631,6197,7654,9502,9633,9048,9343,8737,4282,9438,6768,8780,9437,8736,2473,8523,8523,6204,4146,7089,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,7664,9107,9973,8363,8081,9082,10025,8185,2374,2182,8560,6381,271,539,2729,7304,2729,9438,7903,9300,9480,3647,1215,8306,9425,4598,8874,4598,8241,8244,8706,9182,9349,8337,7928,6768,9417,8245,9898,8922,7,9017,9432,9296,10056,9296,9096,1165,222,3883,10292,810,10259,810,6359,9864,10337,6272,10337,10072,9959,3358,6348,10640,8144,4301,10738,10667,10976,7833,9777,10814,11037,11130,11121,10951,272,10937,10954,9880,11323,6354,10007,2530,104,374,8490,11496,9277,2117,11272,11439,11690,11721,10533,1385,1402,11734,10269,10836,8830,10362,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,7155,9794,9580,9498,7070,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,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4291,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,8323,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,848,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,7568,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,10443,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,8232,7172,1765,1771,4302,9485,6199,9633,6354,222,3073,1351,8946,6499,6214,10208,3385,2387,8714,7698,10663,3071,6497,6689,6496,6212,10731,6221,6218,6498,6501,6223,1770,9407,8584,10214,10335,10215,10216,10213,9868,9501,9084,8682,10334,9430,9587,9591,9593,7764,10199,4804,8323,7762,7570,8585,8719,8717,9590,9535,7569,7568,9588,10139,10346,6371,6518,6519,9119,10202,7631,10331,10432,10521,9429,1770,10565,1765,1770,1771,1767,10247,10637,10639,10646,10641,10645,7844,10752,10753,10552,10257,9905,10644,10750,10328,9631,6201,7870,6199,9951,9407,11046,11055,11047,9949,11050,11056,11054,8324,8596,11019,11072,9084,10800,9590,10801,11057,8584,10324,10327,10333,10329,10331,10213,9906,11033,9970,10043,10253,10255,9907,10256,11030,10925,11032,6197,6198,7698,11037,6199,10552,10561,7772,9493,6532,6534,6535,6533,6505,10239,6506,11069,8154,11174,11173,11175,11185,11176,11186,11181,11183,11182,11184,11178,11179,6198,11176,11173,11151,3073,3070,3071,6689,8946,6688,10053,9665,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,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,8389,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,6214,4299,4293,4287,9726,5718,1616,4291,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,6197,10522,10534,10436,10502,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10424,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,8563,10551,10336,7167,7165,10325,10322,10331,7170,10599,9176,4463,9631,7164,9232,10332,4486,8662,8164,10427,7167,4464,10613,8167,10487,10489,1767,7677,1771,1766,1411,6359,1765,726,10602,4426,7600,6762,6759,7676,7055,8166,10198,10647,10638,10643,365,10594,10641,10645,4464,7169,10600,10601,6416,6386,7168,10642,3897,10102,9114,8331,8336,8529,8335,8530,10322,8832,365,3893,10334,10335,9633,10100,10607,8307,8273,9411,6199,10153,9631,10332,6200,10152,6197,3897,6198,8274,4304,3884,4305,3889,4291,3891,4292,8272,4286,3896,4300,4298,2520,3895,2522,4299,9483,3888,3889,4293,3881,7963,3885,4294,3894,4297,3892,4287,3883,6493,9192,3887,9409,6538,9182,6537,8334,6536,8874,6534,8599,6506,8329,6505,8699,6533,8700,6532,6359,810,1765,7808,1770,1771,1767,1769,10799,1768,10551,1766,10336,10101,9418,9412,10102,9533,3872,8586,10436,9976,10365,8559,272,6715,9857,6197,9633,10232,5435,10698,9857,9667,10731,4435,313,4769,8710,10831,9946,5435,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,8682,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,7695,9920,9633,6197,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,6526,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,11252,11190,5383,11192,11194,11243,10797,11245,7610,11246,9407,8584,11181,11191,11251,6538,6503,8703,7172,11177,7567,11176,7170,6537,11175,7174,6536,7173,6535,11186,6596,6534,7165,11354,6506,7164,510,10639,10752,9518,9521,10753,7168,8917,3719,10637,7167,11320,11321,11461,11493,8585,11218,11466,10849,9520,10923,3894,11019,11422,11431,11459,11407,11240,8247,8242,10606,8703,11191,11193,3070,11375,11432,3073,6354,3071,6689,8088,7752,7753,2780,2789,2812,2791,11464,1589,11493,5792,2779,6896,2787,6688,4512,9129,7751,7972,7973,8946,7184,11148,11147,510,11146,11722,7770,7772,11656,11405,11615,11419,11618,11465,10278,8436,11723,4282,3997,11792,11421,10332,11677,11792,3327,11799,11696,11697,10522,7938,510,4294,10325,11617,11186,11419,11176,11251,11252,11429,11575,11194,9232,11245,11244,11243,11574,4305,11190,11246,7972,3874,4146,11068,11878,11899,11081,11425,11031,11032,11037,7770,7772,510,7771,3282,3719,4580,11051,11033,11080,510,3719,6879,3115,11458,11922,979,11935,8174,11876,11355,7808,9149,11877,11759,10229,7695,1303,7693,8002,10251,653,10389,14,7702,7752,9589,10139,6688,9588,9429,10432,8946,653,9037,8627,10200,9383,3070,10199,9587,8290,8088,6212,9430,8945,8946,8325,8944,8323,7881,9593,2342,10562,1771,10558,1770,10559,1768,1769,10201,10557,1766,8668,9215,8885,10556,10161,7696,8436,10560,6689,8324,10640,10641,9535,6600,8946,10638,10645,10726,8175,9631,10643,3511,9493,7881,8945,8944,9665,10555,10336,10975,9679,8088,8946,8945,7881,9031,8727,9587,9430,7134,9867,4714,10544,11009,10975,8946,10940,1967,7869,2506,9985,8489,8662,10927,10926,11046,10929,538,531,539,10335,10930,7881,8946,5810,510,8489,9867,9679,10544,9665,6354,10975,8946,3071,6688,11022,7869,6272,11047,11167,2506,9985,10931,7600,7567,7770,11239,11254,8278,8478,10647,10644,10641,10640,10645,10646,10642,10940,8946,7881,7546,8682,9084,8618,11051,9473,7567,7570,7569,7764,4300,4299,4304,7568,11218,10298,10238,9475,8584,11019,9920,8585,11405,9473,11194,11139,7869,11296,9985,10298,9625,9475,9867,272,6216,8965,11325,7677,9626,6511,8946,6688,9473,11592,6512,11677,10433,8589,2823,9493,10849,2780,2801,10333,7696,8878,9232,10970,7170,11019,7173,7167,9515,9517,10563,6200,11081,6197,11075,6198,6201,9920,9633,9407,10827,11076,10822,10923,10828,11218,1770,10821,1765,11204,11209,1771,1768,1769,1766,8233,11204,11207,11242,11241,3359,7636,11240,11167,11176,11251,11175,11186,10331,10333,10158,10326,10324,10555,10335,10336,8591,6359,10725,10729,6510,6508,6509,6507,10519,9493,6532,6533,8899,11055,7189,11015,7185,6654,8897,11013,4386,7187,7184,11016,10278,10823,10924,10920,6200,10925,2605,9909,7845,7844,10922,11037,7764,7843,7568,7570,7569,7764,4804,7567,9633,6511,6515,11138,11139,8662,9232,2789,9536,2799,2816,4473,7165,2806,2824,7173,7174,4470,4486,7166,7168,7169,7167,10213,4463,4464,7163,7164,7170,11030,11031,10251,10254,9907,11032,9906,10043,10253,10256,11033,9592,11032,10255,9907,9970,10251,8246,8247,8241,10606,8245,1765,1770,11203,11204,11205,11207,11208,11209,1765,1771,1767,1769,11206,11208,10463,7870,5635,7604,5657,8883,4486,4463,4464,8662,7165,7169,11255,7168,11251,11252,11176,11186,3070,6354,11177,11175,3071,3073,6689,6688,11109,10232,9383,9867,7676,10931,10930,7600,10157,10155,10154,8432,9670,10156,9669,9670,9672,11178,11231,11229,11414,9665,10877,9720,10956,8717,8719,6730,11374,10827,2605,4390,10545,9137,10827,10480,10651,9647,9985,9959,10655,9389,9387,6633,9031,2506,10466,1029,2867,10914,7602,6905,2658,10814,9757,9385,4862,8281,5,10864,10974,2867,10805,10804,9362,11113,9125,1029,8578,11222,10738,11258,11072,2009,8358,11271,7909,5959,915,1029,10937,10464,10441,3647,11267,11312,9403,5810,11448,9763,5962,9062,8884,186,10655,7785,8281,6348,9906,8161,5059,11167,11137,10251,10924,2522,11194,10213,10256,10102,9907,9970,11269,10255,10043,11032,10254,11030,8241,6656,8585,9189,9903,8666,726,6533,11247,11296,10645,10641,979,10179,7605,8729,8435,9767,7107,8946,8512,10471,8109,8230,9300,8903,10751,10056,9525,6971,11587,10474,1616,8526,10867,8816,10803,7815,10074,7751,5454,961,7091,10942,11655,11714,11600,11658,10273,11228,11602,10836,11395,11339,11923,9838,9864,10937,11609,6181,9375,11610,11031,11286,788,6526,6520,6199,6200,9631,10098,6197,10433,9885,6198,6201,6522,7610,6527,7311,6995,6234,6517,11182,11037,7694,11184,6376,11185,11249,6499,11181,11183,10426,10812,11430,7697,11420,11431,7179,7180,7178,7187,5635,11069,11177,7695,7868,3385,6800,6376,6517,6989,6743,6750,6746,4614,7610,7103,11085,6768,11082,8582,6199,6198,6200,9631,11297,10445,3898,10981,6201,10948,9150,10947,8346,8345,7311,11429,9794,8228,1704,9076,4804,8771,7697,3515,7694,1666,7608,3442,7696,7646,7150,7868,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,10811,11254,11297,7186,11418,9920,11251,7870,7188,10821,6200,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,11069,6925,8154,6922,8002,8267,11067,10390,11071,9088,6800,6426,11068,8156,11182,11183,11184,4558,11181,8943,8944,6932,6354,3070,3073,3071,7881,8945,6689,6688,7753,8946,7752,8088,8627,9037,9665,10053,8946,6689,10544,10975,6768,11221,1303,6926,11355,11354,11356,11461,11357,4785,11082,9383,9867,11085,9473,10232,8203,9633,8362,11357,11356,11109,6198,2779,6443,2806,6197,9669,6200,8693,4512,4316,8692,11581,8694,8656,8654,8696,8695,8200,11578,8203,8655,4645,11579,3719,11582,3115,11580,11583,3559,11354,6520,11355,8203,11356,8656,11357,8696,8306,10331,1257,10332,5995,10328,10327,8241,9624,10326,8705,10323,507,11242,9626,10330,8704,11759,10333,8174,4046,10325,4512,11677,11320,11050,10326,10637,10646,7808,8943,10641,10645,8944,11723,7881,6354,10647,10644,3070,10642,3073,10639,8946,9383,10643,10637,9867,10752,10232,10519,6689,10521,10324,3071,10643,10645,6689,10640,11432,11183,9418,11922,9533,6731) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC