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,8312,8334,8309,8311,2779,3511,8314,6197,4301,6604,3581,8598,8596,8324,8340,8328,8728,8268,6654,8248,8246,8244,8899,8307,8243,8319,8241,1929,1932,8308,8333,8246,8307,8311,8599,8336,6354,9115,9182,3070,8597,3073,8335,8340,9184,8330,3071,7819,6957,6689,8334,8946,8241,8244,7752,9114,8699,8088,8627,8700,9037,8320,8249,9129,8946,8945,8944,8943,9665,7881,8727,8945,7054,9679,4558,6447,7546,7677,2261,5460,6876,7285,4947,3493,7068,7840,6646,7838,7903,7168,7775,6652,7184,7180,6654,6653,7188,1738,7185,7181,7879,7183,7189,7178,1521,3625,8247,4386,7187,7176,8089,8146,8248,8314,8315,8246,7167,8249,4464,7186,7182,8316,7614,3542,6713,8319,4218,4470,8242,8313,8340,8336,8317,8599,8341,8311,8342,8305,8322,8337,8328,8327,8325,8241,8332,8326,8339,8314,3715,5373,8340,8241,8330,8309,8325,8649,8598,8335,7178,7189,5379,5812,8332,7184,2989,8326,7179,6652,7180,8318,8555,8883,8874,9129,4131,7188,7184,8897,8899,8003,8896,7751,6527,7972,6372,7187,7014,2029,6527,8938,8918,2006,8611,6688,9589,9535,9587,8324,1953,7249,9430,7582,6842,7844,9911,2337,4944,9214,9527,10139,9772,6216,10045,9454,9773,2782,10246,4082,8888,3413,9160,9973,9148,8641,8055,9600,10022,8063,8575,61,7619,9453,10375,8573,7262,10549,9508,9996,10272,10464,8795,10692,1349,8741,10623,10774,10624,10672,10251,10508,10625,10835,9660,10910,3244,9052,9963,10855,10854,8892,8891,10862,10894,10895,10906,8737,2863,9610,6712,9798,10476,11289,9543,10305,8206,7717,11273,9540,11274,11332,6364,11456,7671,11573,9873,11501,11497,10532,11140,8805,11045,10789,9182,4769,9111,6750,6386,9409,9115,9409,9115,9409,9115,9112,8700,9112,8700,9112,8700,9112,8700,9112,8700,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,8308,970,5386,9182,9593,9431,8874,8342,8340,8337,8333,8315,1765,8248,8326,8244,8241,8311,9889,8700,9839,9879,1771,3071,3073,1765,10229,1771,1266,1769,8946,1411,1165,1767,9149,1769,1266,3066,6778,2605,7083,10522,7933,7122,7124,9114,9592,9410,8329,8245,8323,8242,8599,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,8682,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10217,10217,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6426,6854,6545,6425,6423,6421,9087,6922,10489,8267,6426,6424,10486,11817,8983,8981,6743,3883,10222,1730,9165,9601,3898,9534,8982,6742,10167,6744,6746,6749,979,6359,7599,6768,5386,8879,9217,6750,390,8241,8334,10334,10336,10335,9920,10238,10194,10200,10263,8877,382,8330,8320,8339,8337,9891,9908,9113,10202,9111,8242,8873,8872,8649,10152,9112,9120,9431,8318,9114,9119,8326,8247,8313,8309,8308,9633,5691,1685,5386,6195,1765,10546,10545,7845,9633,9903,9905,6533,2605,5386,1769,8824,10546,9909,9137,8824,1685,5784,10522,9137,9149,1770,8917,1771,1765,10925,8824,8489,7869,1967,9031,5770,4714,10645,10646,10750,11167,10925,10922,9985,10466,8592,5810,390,8784,8788,8881,10613,11051,11248,11247,8882,7134,7877,2071,9303,9350,2506,11239,4714,11022,375,8787,372,376,368,381,6066,387,8858,385,380,393,375,391,386,6082,378,8784,394,6270,8880,392,365,8878,8786,8789,10896,11088,11327,11329,11182,11231,11249,6375,11178,6271,6076,379,6537,11173,11176,11175,5332,1411,810,10521,11183,10827,1266,6535,11229,11174,11186,11252,11185,10921,11238,11519,11295,11296,6505,11318,11294,11239,11254,11301,11251,11585,11571,4923,10731,6600,11085,11665,4520,11666,11667,11085,8175,10823,10278,7922,6354,6503,6523,11425,5383,11429,11085,8713,8713,8737,9832,8241,10545,5332,6216,6501,6214,6220,6497,6499,6215,3892,10644,6898,10520,6656,6496,6212,6222,6223,6221,6498,7100,7091,6218,7698,8361,3898,8232,6359,10827,7660,10941,10942,1327,9649,9424,10335,10325,10563,9151,8162,8667,9150,9144,9518,9520,9521,8340,11220,11205,10687,8241,8139,8249,11206,10606,11203,11050,10139,8318,8247,11007,8248,11055,11009,9416,2780,9415,5297,4390,51,10325,8824,10522,8332,8262,11021,11402,10227,10323,10828,10227,10323,10828,11207,11209,11204,11149,10606,8327,9182,8699,11646,3073,9402,11148,9625,9626,8314,8586,11722,11218,10565,11493,9424,10327,11419,11462,9624,9625,10797,11013,7188,7178,11464,11463,7189,11421,7185,11014,11493,11218,11722,10238,7032,9903,6197,9924,9469,9792,3893,3894,5770,5770,5567,3881,1526,3890,7986,8358,8325,11009,275,11201,8358,11151,11152,11153,11154,11091,8324,11078,8312,11156,10800,8596,11155,11160,11046,4395,9593,10725,10729,8874,8699,4395,10324,10323,10332,3428,11050,541,10326,10325,3883,8244,11161,3428,8330,8337,8248,8318,8326,8272,10828,11394,4614,8824,3883,3888,6872,5066,10892,3895,3890,3891,3888,3896,3889,11589,1770,1765,3887,6493,3897,8274,8271,4936,3883,9024,9024,9024,8582,9840,9865,10480,9633,8897,7698,3254,842,8274,6520,3897,8272,3883,3884,3895,3892,3891,3888,3882,3896,3890,3887,11458,11459,10238,8585,9407,9920,7870,8586,8618,8682,7631,11722,11218,9084,7546,10565,2807,2806,10828,7631,1685,9137,8244,8598,9428,10821,11046,11429,9415,10920,11407,1730,10332,6934,6423,10324,7546,11466,10840,9414,9407,6426,8245,11394,10522,8246,10559,8682,11405,10487,1266,9590,11206,10561,11080,11048,11046,11079,9591,10725,11078,10214,10559,10799,8883,10801,3036,6381,7704,10797,11157,10200,10796,9430,11153,10795,10201,10558,9589,10216,10794,8596,10793,9587,11076,11155,11159,10562,11075,11139,10215,11081,8323,9424,8245,10791,10199,9588,10790,8241,9523,10981,8247,11036,8242,8311,8241,10606,8244,11161,11151,8249,8243,8324,11158,11160,3875,10332,8339,10323,10325,8247,8341,10158,8314,11050,8242,8245,8244,11759,8241,10324,10329,10053,6354,9665,11617,10333,10331,11618,11242,10330,10326,10332,11050,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,11109,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,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,11109,7188,10928,7600,11050,11406,11696,11579,8316,11695,8241,11583,11008,9591,11697,11723,11245,10329,11240,1770,11432,1765,8307,7698,8314,8315,11722,11617,8584,11759,11009,10556,10139,10325,11618,10238,10562,11933,9407,8271,7870,10333,11407,8586,3893,11615,9084,3897,3894,10324,11899,394,11156,3883,3890,10327,6270,10565,11161,3891,10323,11019,3889,367,10331,3888,6505,6076,11242,11318,8273,6533,11493,3881,11241,11249,7546,8274,3885,11139,11046,3892,11154,11159,8682,11405,3895,3884,11153,11218,10606,8241,11240,11050,11759,11677,10322,11049,8319,10099,6261,735,8599,8598,8249,8243,11242,8308,10099,10159,10323,10325,8316,10096,10217,10324,10922,11149,11618,8311,11759,11932,10726,11137,10326,11161,11405,8312,8313,8248,8245,10799,10970,11617,8584,10828,10427,11294,8308,8247,8317,8315,8246,11407,11933,11934,11697,6381,4287,1767,11049,10551,2265,10728,9217,9231,10801,10526,8961,9147,10170,7904,8517,3884,8272,7986,8961,8874,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC