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,9535,10200,10139,10201,10197,10215,1768,8387,381,380,10199,375,7188,394,372,376,10217,176,9430,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,10928,10927,7676,11082,10931,8681,6221,8698,6223,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,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,7143,11121,5995,173,7636,365,392,11263,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,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,6354,3070,3073,3071,6689,6688,9679,8943,7753,7752,8088,9037,8627,8944,9665,10053,10975,10544,8946,8727,10930,10844,7881,8563,8945,10927,10926,10931,11082,11085,7870,8586,10930,10975,10928,9522,9515,9517,9520,9518,10379,9521,10522,2643,10521,10346,10546,10463,10436,10402,10750,10612,10827,10545,11011,10332,10327,6197,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,9430,10200,10560,7696,4293,4305,10322,9114,9426,9424,9409,4298,9112,9113,8883,2824,10136,9894,9633,4304,10215,8662,9908,4294,6200,2825,10218,2823,8727,1765,9120,8326,8627,1771,9626,4296,1768,7174,9037,6689,1767,2808,1766,510,1771,9473,8944,9669,9407,7752,7677,8627,9920,8432,9474,10154,10725,10642,8971,10139,9665,9475,10155,9601,10298,10729,9493,10238,10522,9383,10637,9867,8586,10152,5576,10877,7636,10232,4386,848,1368,9687,10828,7580,9031,10641,11048,11008,6800,11046,7870,11088,11019,10329,10864,9854,9911,10645,11007,10565,9912,10463,10647,11047,10866,10923,10646,10154,4464,11014,9046,7019,7165,10155,7166,4486,8780,9215,4470,7761,10157,7677,10156,7551,8222,2818,10519,11051,8793,4855,2816,11183,11184,11022,11192,10706,11193,9168,10053,11191,2780,11241,11231,11242,9690,11149,2791,10544,8964,6197,9534,8003,6332,8278,10727,10563,10559,9231,10646,10812,9892,10044,10426,10487,6212,7843,10417,10489,7844,7845,3890,10545,10389,7196,384,10381,6443,10520,8579,10040,6517,6216,8242,10925,7704,10923,10729,10560,10199,10558,10557,10200,3894,3957,1764,10823,8882,11080,4302,8274,8250,11091,4512,2555,8696,1086,4316,5003,10318,2039,4774,9386,2998,10486,6535,9493,11153,7299,10045,6143,10935,9903,10828,4827,5208,4645,9418,6986,10513,11106,10820,11198,11246,11067,11219,11230,10483,10924,11068,11071,8827,11069,11254,11296,11270,10921,11238,10931,11306,6648,10930,6423,10642,4299,9591,11048,9888,2605,10923,10922,8002,10644,10561,7762,4293,11156,4287,11317,8596,7676,10201,11320,10645,11321,11158,6521,10562,10647,10643,7987,3070,6354,11008,9535,6689,3892,3071,3073,2643,10937,11324,11152,9147,11432,11467,11479,4146,10426,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,9632,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,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,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,551,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,531,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017,8582,2808,2812,2781,8154,11071,11068,11067,9555,9554,8241,8244,3784,2817,6354,3070,3073,3071,6688,6689,7752,7753,8627,8088,11161,9037,6526,11238,2820,6521,2794,2789,3891,3877,4305,2818,9665,10053,10544,10975,524,11221,526,9383,9867,529,6855,10232,8943,11407,8316,8944,9418,7881,10644,11390,11393,10640,8878,10645,374,11422,11406,6538,11320,525,6537,538,6536,535,6535,542,6534,540,11321,6506,6505,6533,6532,4599,4598,8727,382,735,9184,9679,8596,6442,2824,7999,7998,10857,10866,11523,11131,10930,10931,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,7755,7754,7554,10564,7756,11985,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,9632,8362,11357,11356,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,3719,11697,8618,8682,9084,7172,9407,10238,11019,9920,10565,9084,7631,11218,7184,11016,5635,4386,7179,7189,6652,7178,7182,11240,510,8897,7770,7180,7772,7771,511,512,8946,6654,11013,6688,9473,11014,7181,7183,11354,7176,6653,7188,11419,11421,11422,7187,11418,11420,9407,9084,8682,10565,10238,9920,11146,11147,11148,11015,11082,11392,9437,11019,7998,4386,9129,11218,9671,9670,9669,8946,7186,11464,11493,11462,11463,8172,10750,11431,8007,6596,9233,10433,11017,8971,11430,11414,11429,11321,6836,11498,8610,11446,5988,11521,10472,6521,11181,11487,11495,11427,1347,5339,5545,9084,9920,8682,11362,8681,9958,8698,11468,848,9492,6216,10864,11269,11649,11349,11664,6497,11377,11378,11678,11069,8154,10042,9638,9220,10941,11493,11647,11349,11724,10895,8900,9638,9220,10569,10787,10856,10042,9904,9086,252,5373,11126,11678,6713,11237,51,4082,7550,8837,5193,3018,10367,8780,4401,10824,24,9896,11355,1770,7184,8306,6713,7185,11016,11647,11463,11464,7176,11488,11664,5255,11876,6800,28,10942,9492,11093,524,543,553,539,535,529,532,554,7124,7078,9933,11592,7107,3888,11624,10482,9439,9290,11349,10354,9601,9334,8902,11724,11981,9888,8542,8434,10442,6740,11121,11690,9300,10056,8541,8922,1190,6836,9233,11622,8582,6240,11442,8819,2294,156,3080,5817,4460,7883,2933,608,11221,7696,10925,11178,11179,11183,7693,11037,11146,7870,4294,7189,11015,5635,11148,4386,9909,11331,10889,10920,10475,7697,4,11255,10863,10835,10921,10923,10486,7694,2605,10828,979,9149,10545,10840,11177,11375,10075,10520,1685,10521,1266,4390,4282,1411,8696,8695,8654,8656,11175,5297,6359,10827,11249,7808,9137,5332,6995,8694,1769,1768,10522,10922,11154,8655,10027,3442,6520,810,11251,10029,11317,1685,10546,11185,11182,11181,11186,11318,11184,10924,10639,10641,10645,10646,10643,10642,9880,10644,10647,10753,8693,11458,10644,10822,9933,8694,3895,8692,8655,10645,10637,11252,11321,11176,11590,11432,6354,1766,8946,6688,10331,9794,7881,7753,7752,10053,3070,9665,8627,11584,9679,9867,10544,10975,6689,7266,10927,3073,10926,7676,10930,10931,7600,8727,8088,10232,3071,11582,11578,7188,7176,7186,7178,7187,7184,8897,7181,11419,7180,6652,272,11422,11013,9037,6654,11148,10928,11016,11221,9250,8944,7183,9223,8945,8943,8011,8247,11431,7182,8585,11418,510,11149,11601,9383,6653,11723,11579,7179,7185,6426,11019,11218,11493,11722,6271,10329,10333,8241,10332,8337,11420,11465,1303,11176,11650,10327,11427,11429,11463,10931,8727,9920,11421,7870,10323,8883,8310,10565,11147,4386,11464,10238,8333,10555,10640,9407,10216,8308,8314,11146,8244,7151,7024,8318,8248,8585,9120,11466,7663,7103,3874,10519,10641,4146,10639,8880,394,10643,10752,1266,11799,9037,8787,10637,10647,10640,11723,10646,11321,11836,10931,10463,7753,7752,8325,11624,7604,8088,7600,9665,10975,10053,8627,10544,3071,10644,8944,8943,10642,8727,9383,9587,9867,10232,9589,8945,11221,2605,8946,6354,10926,8897,10927,10928,10930,8323,8321,7600,7676,11722,11899,11836,4146,10948,6270,7184,11981,7185,11014,10641,11015,6654,7179,7183,7181,7188,10928,7600,7676,7631,8088,8627,9533,11221,10544,10053,8656,9665,7928,11836,10975,11981,8727,10931,7600,6688,2803,3070,11988,2799,2787,2781,7179,6653,11985,8654,8946,9867,8945,10975,11627,11877,8583,7870,7600,10565,10942,9920,10238,10943,9624,9625,9626,8087,11246,11722,11019,10941,7150,8944,8943,10067,10931,7546) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC