this<h2>MySQL returned error</h2><hr><br><br><strong>Error Description :</strong><hr>Error No : 1064<br>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<br><br><strong>SQL Query<strong><hr>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,8248,8314,8339,8320,8313,8598,8338,8271,8272,8335,5297,8088,8727,8003,7881,8627,8260,8873,8872,8946,9115,9113,9112,9111,9114,9119,9120,8872,8088,3719,3115,3559,8705,8704,8174,3115,3719,3559,8946,8003,8333,8309,6371,8699,6372,8317,8332,8330,8328,8312,3559,8704,8174,3719,9625,5995,9592,8306,9411,8088,1257,9410,4947,3493,2033,2915,9383,6710,9661,6986,6876,9910,10102,10101,8031,6779,1881,9749,10227,10229,1520,8681,8698,8817,1308,1626,1215,7839,5386,1165,6359,5332,6521,4701,1266,6792,6201,6198,6200,6199,4282,4301,4299,4293,4302,4305,4297,4301,3515,7693,6505,6533,6532,4286,4304,1704,4289,7972,7973,6218,6197,6501,6497,7698,6498,6215,6216,6496,6222,6221,6212,6223,8244,8249,8246,8243,8339,8245,8247,8248,8318,8317,8319,8320,8334,8326,8337,8330,8327,8315,8331,8335,8322,8333,8325,8324,8323,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,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,8310,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,8308,8333,8246,8307,8311,8599,6354,9115,9182,3070,8597,3073,8335,8340,9184,8310,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,7580,9120,8682,8320,8330,3875,7094,8896,8681,8698,8899,8244,9041,8698,9184,9041,8656,8696,8945,7636,8694,1368,8692,8946,8693,8695,9037,7753,6354,8817,3073,7752,8943,4701,8946,8727,1769,8323,6371,1770,6223,1765,9037,1767,8248,979,1769,6599,1768,7631,6359,3115,3071,8704,1770,3719,8340,8705,9114,507,9149,8174,6354,9137,3559,7808,9278,9383,5297,8943,7753,8944,7752,8943,7881,1770,1767,1765,4716,1769,1767,8276,1768,1245,510,8275,8591,7751,9515,9407,7972,7973,8946,7592,6688,4944,7546,7748,7753,9665,321,9626,9037,1303,1770,222,1765,7020,3073,8943,3071,7963,7881,8944,9601,9084,9624,7772,8618,9867,7770,8585,7185,7771,7187,512,9806,9907,7637,9906,9911,7753,9958,7752,10053,9720,6688,8727,9722,8946,9721,3071,9723,272,6600,10232,9215,1765,1770,8815,10255,9624,3719,344,10254,9720,5484,8598,8317,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,8387,7610,7697,7694,7695,7696,3442,7608,3515,8244,1665,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,381,379,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,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,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,7157,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,8389,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,6371,6804,501,4234,7304,3989,1462,3247,4860,2594,6740,7932,4796,7238,3830,1167,8220,7602,947,1126,6010,6971,4395,6710,5371,4512,3913,8241,8334,2041,8337,7022,8248,6751,7910,8019,8323,9430,9113,8243,9431,8323,8249,8599,8333,8330,8337,9426,9183,9184,7693,1768,8307,8309,9416,8246,8335,8241,8315,8326,8700,9415,8312,8311,8316,8313,8322,8331,8327,8334,8320,9424,9428,8317,8598,8245,8597,7546,8583,8584,8585,8329,8682,7631,9407,9517,9520,9112,9119,8247,8314,9409,8272,8872,9894,8342,8649,3359,9182,9407,1768,8088,3071,6688,8681,8817,8698,10753,4512,10232,9867,8944,9084,8586,8332,10645,8875,9114,9120,3897,10102,9114,8331,8529,8335,8530,10322,8832,365,3893,10334,10335,9633,10100,9632,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,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,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,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,10726,10728,10555,8244,11042,2709,9416,8917,11082,11085,2743,3613,8260,11050,10522,6600,1762,1681,11050,9792,10606,9231,5656,10970,10607,8319,3613,8874,7370,6485,5516,8599,11050,10324,8875,10799,11055,8598,11139,8699,9112,11009,10963,8193,11008,11137,11149,11048,11047,11151,2826,6442,11054,11157,2827,2825,11057,8242,11160,11159,9409,11138,11161,6489,2815,2823,9184,9410,11158,2822,2821,2824,11156,11240,2816,2817,2820,2818,9407,10565,11218,2806,2808,2807,2812,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,10176,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,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,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,10176,10218,11301,10100,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,8315,8334,8337,10545,979,8327,8331,10646,10647,9426,8335,10645,9149,8330,8333)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC