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,10186,10166,9850,7834,130,217,7903,7835,7836,9616,8441,8933,9297,4406,9933,7674,10072,7674,10072,9880,148,8816,8358,8,1645,1559,9888,1559,10400,2555,1345,10274,7077,7655,9741,9053,7088,9225,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,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,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,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,9632,10238,10053,6242,9880,9622,9205,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,7833,8435,8441,8290,9017,8628,7910,9072,9073,9073,5207,9090,8780,8780,9215,8615,8615,8991,9389,9389,8706,8706,585,4805,4805,8922,3474,3474,8534,8534,6188,6188,9545,9545,6104,9767,9258,9108,9931,9959,3558,637,9319,9319,10056,10079,8927,4985,4985,9993,9993,10212,311,9464,4639,9838,9838,223,223,7823,7823,107,10523,10548,10548,10608,10608,6642,6642,8547,10702,10626,2989,10667,10667,10836,10814,10814,10938,10512,10738,10738,9757,9757,10972,10976,10976,11027,10977,10977,11121,9555,10228,10228,11089,10904,1461,11219,11172,11172,10039,10355,10355,11272,11272,1439,10748,10748,11310,11310,11324,11130,5321,2160,2160,7583,7583,11455,1381,1381,11353,10937,11496,11604,7904,11554,9777,11609,11690,11741,10397,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,9632,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,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,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,2342,10218,10379,6215,10438,9394,6538,6656,1296,9342,6373,10305,6512,10369,10631,10687,8710,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,8292,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10984,10402,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,8389,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,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,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,8878,7171,4798,735,7174,7172,7170,381,8880,3442,7173,7677,380,9624,6197,8154,730,10321,810,4390,8824,7808,9647,3549,9389,5334,9387,10259,6780,10655,2913,9872,9963,10056,8305,9258,7130,10212,10712,10714,9295,3046,10724,10738,10342,10702,7882,9063,10763,10734,9868,10111,10364,10649,10786,8955,180,10715,10550,9736,9300,10836,10839,10838,3712,6348,8151,9838,10549,10837,10721,10547,9453,9864,6712,9900,9349,8219,8706,10937,7928,9072,10751,7776,10910,10974,10865,10086,10362,10913,7909,10090,10089,11022,10915,10088,10087,7998,8828,8182,10679,11043,10818,9090,7910,2261,8586,10821,8341,10638,9517,10797,10827,9920,10645,510,7178,10467,10820,3023,10796,7179,9534,10795,10640,10257,675,10321,11019,10970,10647,10642,10977,10646,2451,3334,10637,1210,9418,9907,10643,4791,2677,947,3803,10552,2736,3392,5459,10938,1533,1425,7772,4645,7770,956,7771,1741,1370,511,512,173,7637,4535,11137,10278,9493,11043,5251,11121,2995,4029,11138,4779,4762,28,3564,5431,1198,4731,11149,11218,11183,11184,11181,11037,11182,11185,11219,9880,7019,57,7238,6740,11240,11241,11321,11320,10822,11242,10742,11324,10840,10579,6354,3070,3073,3071,6689,4146,11387,11239,2506,7752,11115,8088,11455,7019,7761,8222,8793,8088,7636,8627,1368,11493,9037,5053,8943,1762,8793,9993,8816,8946,5576,10337,11677,11644,3875,6354,8668,10520,979,8824,9796,7107,7104,2605,7546,11301,11299,11321,4936,1250,6272,8241,10642,8244,10640,11294,10637,9601,11571,11247,9149,7904,9067,10381,858,8498,10846,10161,8345,11051,10676,8878,376,365,5810,9975,10033,857,858,3254,6754,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,8682,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10637,10199,10642,11055,11138,9232,11049,10799,8875,9113,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,551,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,8682,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9425,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,551,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11723,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,10378,10088,10090,10684,11043,10086,10915,10353,10454,9916,6041,8681,7721,8698,10805,9910,10448,6444,10739,8584,10251,6023,10193,7917,7054,10332,10562,9429,10139,3071,10559,8618,10557,10726,10215,10325,10326,10327,10322,10218,10328,10334,10330,10331,10333,10329,8943,8944,11019,8885,7752,11033,9970,11047,4923,8787,9555,9522,510,694,681,391,8880,378,365,372,385,9231,389,8878,381,6066,9150,9143,1769,7881,380,11022,11057,11247,11269,11238,11254,11296,11051,11239,695,9031,8244,10555,694,10801,6540,9429,6544,11157,10199,11218,10556,10251,9970,8784,9906,11151,8882,8881,10463,11207,8343,10214,11154,10558,8883,6270,10216,9184,549,393,10800,384,11407,11392,9587,8323,10561,11299,9147,9154,9155,11078,9156,9792,10957,9217,9151,9146,11405,387,9191,8858,8789,386,8788,375,382,11209,11052,11294,11320,11461,11406,11462,368,461,7861,4259,11077,4251,6788,11081,11079,3895,3893,3891,3887,3894,3890,3888,3884,8272,6493,3897,3896,3892,3889,3885,3883,10725,9259,10920,10923,10561,7119,9206,10214,10563,6270,9148,10216,8339,7933,9905,10194,10195,10922,10862,10333,10821,11137,11048,10921,11139,8729,10200,9587,5635,11146,10199,10925,10201,10328,11147,8897,11013,10558,10330,10329,4386,11015,10331,10098,11014,11016,10323,10443,11022,11154,11148,7186,7187,10215,10607,7176,7180,2799,11157,7179,11160,7182,7181,7183,7185,9590,11156,7178,8596,10139,6654,10557,10560,7189,10800,9535,7184,11152,11153,6652,11051,7188,11240,11138,11247,8878,6653,8880,10335,11269,10551,8243,11167,11242,11033,10253,11241,10153,9970,10043,11031,9907,10256,8330,11296,11294,10728,10519,10799,9492,1245,10336,10970,5096,8248,11030,9410,10254,8327,10218,11301,10100,8336,11022,6688,10803,6689,8946,3071,3073,6354,3070,6689,8088,7752,8627,9037,8727,10805,11221,6212,6215,4714,11238,11318,11317,11405,11406,10828,9880,10822,8343,11427,11431,374,11426,9903,11421,11422,6271,11419,9905,1250,11420,11418,5383,10804,3359,9679,10840,6689,9473,11464,11463,11252,11430,11466,11493,9806,11241,10565,11019,7169,10238,1766,4464,9084,7546,11218,8586,8618,8682,9590,10551,10323,10322,11050,10332,9434,11242,9435,10331,10327,10325,8531,7986,11241,3884,3885,3888,11017,8971,6263,11458,11459,10292,6836,6834,10328,6835,11467,11319,11167,11301,11299,11239,11301,11238,11247,10466,11022,11254,11295,8345,9031,7869,5810,4714,11294,11296,11493,10804,3888,10606,3887,11269,11484,810,11051,11181,7610,7698,10922,10921,10923,11518,10821,10687,11435,6270,390,6789,7006,6076,6880,374,11601,11460,11422,11655,11207,177,11656,11203,11659,11247,11663,11346,10873,11600,526,531,542,524,1557,6385,8820,8007,549,6380,11301,11269,11247,11254,11022,735,11568,11650,11317,11318,10922,7083,550,547,11665,11791,11427,6527,11051,11194,11244,11601,5383,3070,6354,10925,10923,810,10827,540,532,8788,394,8786,8858,6270,375,390,6076,548,6066,537,541,8880,8878,7693,11467,11611,8784,8787,391,6836,11081,11079,11080,11878,11877,11602,4282,11296,11075,11876,11077,392,538,11903,11078,6076,10921,11173,11174,9523,11183,11080,653,10612,11602,8787,3997,2520,11791,11405,11759,6520,387,11432,9217,11078,11799,10637,389,8530,6042,10794,11069,10151,11247,11254,11817,9165,6271,11897,11677,11696,11238,6200,9633,6198,6199,272,6197,11252,11251,11186,11177,11176,11175,1770,1765,1768,1769,1767,1766,11229,11231,11179,11178,7569,7570,7762,7568,7567,7764,4300,4297,4287,4289,4294,4301,11430,11429,4293,11728,7845,7844,8034,7716,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC