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,275,6743,6390,4659,6133,1167,2263,6633,6209,6240,5566,3425,3896,5883,860,6382,6749,1970,6907,6904,5822,3882,3883,3891,7293,7270,3884,7124,3888,3888,3892,7124,7251,7292,3890,7094,1366,6493,7155,3891,7095,3893,7083,3889,7087,7072,7100,7122,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,7089,3892,4724,7277,7251,8197,7986,7247,8393,1626,7088,8384,8449,8384,7663,8439,8577,8085,8386,8206,8205,8401,7940,3895,8646,8412,8772,8080,8240,8368,8274,7649,7653,8737,4805,6209,9056,7713,3881,3883,4220,8269,5454,8468,7671,9053,6863,8461,4233,8271,4209,9132,9402,458,5484,3894,4519,8893,4800,7985,9481,5777,4690,450,1569,9322,8257,9418,3244,9915,9934,8268,8644,7108,9417,9793,9367,8229,10078,5484,8398,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,2954,6188,4337,4185,4178,4767,1038,4199,5331,5995,446,5020,3026,3904,2054,5286,2262,359,7092,4185,1433,2954,7713,4199,7714,7807,7804,4234,501,5373,1559,5046,6863,4355,7835,7836,7834,7836,2025,7837,3732,7655,7655,7280,8027,8027,8027,8030,8030,6190,7238,6176,5371,5998,6362,675,1402,3913,2261,4405,6811,435,4419,217,4784,3595,6667,1359,1811,6003,2736,6003,3327,4639,2417,228,6792,233,452,6275,7986,3059,3059,3059,5535,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,6368,7020,2944,2387,7238,4624,7951,4901,6658,5131,4406,8222,4178,4340,5763,6703,752,3457,4023,6809,585,3908,5764,6740,6104,3913,4950,3474,504,7238,3715,1016,3368,3933,7937,7903,8220,4337,4901,4901,8306,8306,8306,6151,8228,6750,6521,6521,6521,3612,7614,7614,7705,7199,7195,9165,7162,7198,653,3875,7196,7191,7194,8988,6385,8984,9592,2520,7199,6925,7200,9087,6926,6931,3277,7190,6386,8986,9172,9885,7199,9177,8986,10044,9175,7196,10045,6931,7192,6936,6935,6011,8261,1516,1272,8187,2986,7994,6113,8110,7970,8091,7124,6955,8608,8547,2520,1586,8358,7607,7239,6119,8305,6979,8306,2246,7982,1050,2766,6328,1051,7599,7615,1557,2946,8541,8483,7093,8742,8914,1049,6905,2507,6740,9053,8554,8933,9107,6788,9030,458,5052,4154,6261,4639,7238,8220,9300,8761,5063,8651,1556,5165,9259,7619,9381,8628,9336,7910,9327,8290,9465,9387,8208,9450,9538,9547,2253,9331,9647,9652,8063,9754,8542,206,8403,9788,311,9789,2913,7900,220,4395,9257,8763,9889,9046,9933,9967,186,8434,9963,10026,130,7671,2487,104,609,10163,10050,8439,236,10182,10073,10177,10225,10144,10257,9824,10261,10234,10360,10519,10518,10541,10547,10714,10615,10820,10876,10910,5790,10712,10979,8206,11094,176,11010,10905,11200,9967,7250,11096,8282,7660,11371,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,8816,9029,9009,7599,8943,9009,8944,7595,7881,4969,2029,4983,3169,8141,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,3719,8701,8175,2018,1764,7592,6894,5175,1823,8169,4136,7582,2337,7016,1920,3625,5005,5286,1257,6713,7759,4741,5081,1521,6866,7875,4258,4739,6707,1895,4131,2703,3936,784,7839,3129,3542,5614,4082,6986,2294,4209,4596,748,3080,4566,1134,1439,3413,4656,3117,5817,1347,5732,3134,7005,2944,3913,4460,3115,3976,6117,6793,1738,6595,608,4100,6639,5339,1253,5545,1215,6684,7126,3341,6858,5812,1347,6314,2933,7138,7156,4652,6713,608,6635,7559,6858,222,1349,7581,222,6857,7550,836,6679,2023,3454,797,4088,6792,7839,6674,8220,6703,7354,2875,4773,5025,5541,3368,8031,6686,8548,6337,6942,8548,3080,6986,2737,7875,4513,8134,4194,7615,5379,2944,3263,1127,3162,4432,3195,2419,5629,6732,3201,3701,4740,4613,8543,1432,5477,8224,2387,8615,5175,8006,1532,1298,4539,8146,8587,1089,4875,4023,1698,609,2446,8535,8105,2594,3003,7896,6861,7709,5807,6124,6809,4411,5215,7362,5536,3558,8089,3244,3391,5020,6704,6595,2018,3559,8175,507,1439,36,6845,3139,3288,6880,4538,6610,4258,8999,8900,8837,922,8101,6348,3440,3647,3647,659,7828,1183,7008,6770,9274,4068,7213,7374,7374,7951,7951,5965,4774,4724,9975,9417,8144,8144,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,4735,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,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,8141,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,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,5371,9977,6740,1589,222,10940,7238,10844,5134,10296,8306,223,7143,2749,11349,7837,8780,10734,2253,7910,7592,452,9884,5678,3327,10687,9835,2989,9949,3282,11480,11443,11134,11372,10819,11850,9884,11446,11663)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC