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,4774,4720,7105,5995,5995,7913,8220,6740,6740,8547,2627,2627,7239,6621,4860,6139,2882,5997,6155,1108,314,5908,6102,5256,2113,3037,4730,4766,6104,5995,2324,5247,5088,6829,931,4412,1825,5883,2156,6633,1052,4898,5962,6825,1038,6006,3358,6364,7878,4555,7276,2845,6741,8095,8064,7262,8022,4130,2594,8078,1010,8403,7719,4770,2182,8516,8306,1645,4728,4254,1257,4767,4233,8578,1559,5373,8722,8552,8289,8639,2989,8,3989,6154,7374,8841,8095,934,8587,8915,3262,5763,3297,8144,4337,8615,2381,7919,5837,8484,6907,8836,7904,5065,5066,7834,8580,7836,9058,4670,9305,9318,9269,9254,9333,9387,8220,5267,9421,9322,9365,9459,9509,9338,9479,9403,233,7928,6103,8628,4800,9366,9526,9641,9656,9763,9770,9028,9136,9527,9406,9798,6857,9648,9347,9634,9871,9930,9942,9750,9947,2985,9030,3479,9968,10008,9950,9935,6738,8776,10060,9978,10011,61,5477,3933,10061,10079,320,1268,1536,3162,3612,10108,10172,10128,2093,9951,9954,609,9439,9045,9032,7833,2137,10210,10228,9998,10221,1815,10303,1816,9214,9059,8891,3701,10354,10338,10307,10366,10375,9832,10351,8139,10482,9245,9807,8828,10523,10481,9373,2025,10615,585,3904,9043,10666,10648,5795,10258,6700,6548,10569,10244,10568,9904,8900,9831,8837,10548,8925,6713,10870,10880,10895,8888,8901,8902,10857,10767,9086,8089,10702,8800,10911,7828,10619,10620,10705,10621,10899,10142,10903,10935,7807,7262,1886,8389,324,7209,4659,1327,1084,4362,8434,7971,8541,8408,6658,7975,7928,8290,1887,8435,8706,8737,8742,8363,7143,2775,7961,5244,6850,3440,7747,8922,8628,1250,2093,1324,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,1324,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,7097,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,6832,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7993,7804,4339,2027,7715,7079,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,6193,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,6104,504,6103,7239,6364,3728,1232,7019,6981,3531,7374,5914,1145,7878,7143,7840,7761,7872,7903,7937,4535,7910,7938,3549,867,7358,2389,3419,2182,7770,7771,8169,511,7911,8222,7108,8231,2467,3029,8288,512,7637,8358,5995,4983,7085,4765,4985,8469,7271,7828,3115,3559,8174,2117,8547,8626,507,7928,8705,8704,8706,2473,8706,8480,8304,8706,7125,7775,7077,3725,8683,8087,8818,7751,7972,7973,4406,8213,2989,8908,8909,2989,8776,8836,8910,8947,6821,8816,9029,9009,7599,8943,9009,8944,7595,7881,4969,2029,4983,3169,3532,9198,6138,9202,1230,6138,8812,7589,4701,9216,9278,1770,9307,9331,9330,9349,9334,7998,7999,9277,9422,9479,9546,9212,9558,9612,9613,9646,9649,9383,4985,9727,1768,9736,1766,9770,1890,931,9767,9759,9386,8543,2294,223,9799,9887,9871,4405,7265,8419,9978,9884,9979,10001,10001,10053,10072,10001,4784,10111,9378,9989,8211,10073,10108,10073,10121,8780,10121,10225,10237,10247,10104,7139,9148,9377,10219,8554,10163,10124,10261,9900,9093,10123,7675,9116,9834,10293,10273,409,9257,10492,9423,10531,7777,10543,7766,10543,8914,10543,10209,10129,10127,10467,9136,10818,10724,10976,10649,8842,7634,10412,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,8962,665,2998,8999,8182,4901,8306,1245,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9981,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10355,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,11304,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,11457,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,566,550,1533,923,7238,6740,466,4788,2736,2995,3564,1370,1917,4645,4785,1145,5988,788,7121,7097,6659,3392,2915,7245,7108,1520,3059,2261,3493,3595,7019,4947,7761,179,1461,6710,7008,2986,4234,6642,1327,721,8085,2775,2776,1886,1207,2725,8222,7019,1198,435,5251,5143,8185,8185,8434,2451,2932,233,501,4861,1425,4512,4316,5298,5298,5003,737,4037,8470,8685,7808,2605,2605,3989,6382,4038,3841,6144,7244,6149,378,979,7285,8793,8340,8246,8325,2520,947,7359,1126,8241,9030,8424,8204,8334,8568,6082,8874,7998,7999,8328,1173,3169,842,217,698,9182,3389,6774,6774,9204,4240,9056,8445,7675,7087,182,7116,4301,4301,9053,6042,545,539,537,7986,7654,7125,7985,543,7999,9870,2677,9533,4784,7117,9418,9554,9676,1234,956,1210,1741,542,9378,1768,28,4029,3014,3891,3895,6493,3803,9878,9877,9874,9875,8459,8469,10171,10171,10187,8446,8445,10272,8363,8423,8891,8892,9082,10399,10451,9207,10011,10400,9224,10706,10759,9649,10702,10401,1257,9674,9401,9297,4401,9968,10938,10802,10991,6342,7852,8963,11089,8437,10667,10888,10887,11188,11402,7080,7661,11370,7655,10768,7655,8721,8737,9658,9199,8712,7933,9398,11189,8517,1029,8306,6785,8151,7143,2729,8721,4983,8389,6155,7287,7089,7285,8399,8206,8447,8446,7268,8444,7766,7672,8425,7668,6123,6633,7112,8361,8050,7273,9297,7835,9422,7834,8362,8639,36,8741,8200,8055,9543,9275,7261,7096,7287,8640,8207,7245,7574,8059,7984,7941,7939,7940,7943,8061,8066,8253,9719,8475,7666,8643,8419,8202,8722,8427,10056,9444,7085,7249,8469,8086,8792,10008,9959,8431,8426,10089,10090,8468,10087,7585,10190,6821,6205,6907,8071,8741,8737,9658,6133,10002,7792,10088,10808,10815,126,10786,10777,9199,10855,10864,10836,10870,10876,10875,10807,7008,7785,3440,11095,11131,10583,10584,10494,10011,10854,6006,1740,3875,372,9053,6977,8220,7903,9029,6740,9300,7238,7833,7833,7143,4544,7905,582,4503,7885,7666,7096,7118,7246,8646,7069,4752,9817,8081,10077,7674,8036,7574,9819,9748,9747,9746,9818,9820,5995,7268,10272,8087,8431,8741,9998,8082,8743,9316,10451,8207,10464,9300,10056,10836,10890,9056,10450,6240)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC