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,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,8571,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,11912,11913,11893,7115,7906,8063,7068,8712,7085,8048,8368,9083,7080,9053,9148,7244,9057,7944,7287,7287,7111,9259,7282,8404,8713,8044,7152,7671,8080,7935,8460,8709,9398,8652,9225,9225,9560,7279,7279,8364,8364,9755,9225,7080,8408,9199,10030,8364,10023,8363,8232,8232,7266,9956,9302,10076,9999,10024,10024,9956,9956,8229,10046,10278,9421,4624,9980,8782,7654,9813,9878,9755,10811,10768,9794,9561,10767,10769,10869,9316,10833,10854,10757,10855,10770,11038,10675,10890,10854,11210,11210,11262,9739,9875,9874,11335,10623,9873,9873,11225,11514,11331,8205,10572,8063,9739,11692,10027,9740,8055,8794,8769,8049,8368,9739,9621,8711,8052,8078,8056,8049,8058,7931,8770,9738,8736,8286,8645,8711,9719,10075,10077,8721,8398,8792,9572,9540,10506,9622,8411,8055,10507,8414,10573,9204,7262,8473,10587,9445,9313,10690,8049,8397,7293,7671,5252,2117,4417,1318,2117,3250,423,1831,3520,5305,2985,6845,6104,2780,2785,6996,3070,2518,3555,2342,2374,6999,243,219,1245,5088,6390,7785,7926,7870,6633,7761,4931,7796,6982,7774,8351,4395,7989,7830,7713,7115,7116,7152,6971,501,7878,8048,6261,8503,5795,1461,7761,8222,3059,2709,8924,9362,9374,9374,8584,2706,4861,8506,9831,7107,8251,8948,10265,10306,9748,9890,10555,10479,10862,10937,11325,8208,11497,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,10449,10881,10693,8739,7249,8638,10009,7932,10862,10835,11127,10820,10890,10629,9540,11027,11162,9080,11103,9754,5965,9329,7585,11232,10702,7694,9959,10089,10566,10747,11372,11516,10768,11476,11331,11479,11628,11629,9509,11480,11225,11409,11453,11711,11689,11339,10614,11712,11453,11778,11675,10749,11685,11382,11484,11845,11477,11417,10397,11846,10272,9141,8063,10051,10630,7275,10076,9157,10026,10770,9437,9438,10078,8577,9744,9957,10475,9999,10887,10862,10024,9745,10881,10811,10882,8908,9264,9577,10271,10572,7271,10074,10773,9660,9813,10609,10889,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,8055,7080,7112,7664,8368,7084,7244,8033,7241,7280,8572,7932,7081,8647,8065,8642,8448,8417,8769,8635,8645,8405,8049,9161,9793,10022,9973,10586,9819,10617,9161,10807,8079,11332,11337,11471,11535,10690,8430,9261,10572,10689,7272,10403,11542,11504,11503,11506,7354,4566,6683,10770,5596,9377,8808,10674,5431,1234,173,4432,10226,10079,8927,9900,6397,10272,11262,11187,10146,5513,145,11335,11381,9922,6278,1775,3368,9338,11287,5247,7250,11108,5236,28,9464,7876,10397,11225,7662,7661,4023,6679,10893,1145,9888,8568,8424,8740,9977,5175,4023,4061,4969,3989,6595,228,4233,9968,1398,11630,7143,11652,11633,7671,9560,8812,9251,10168,8813,11517,10748,10472,10675,11684,9417,10904,9036,8517,11703,11658,11442,9874,9873,9876,9875,1173,713,2995,923,11388,172,8474,1970,8929,7655,8081,9205,10854,9461,10855,9503,8889,11609,11385,6635,9980,9896,10869,11398,9246,8140,3558,10078,11753,8139,6548,11795,11473,11689,11794,10624,9220,10860,9638,252,10042,11822,9904,11838,11130,9401,7670)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC