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,4178,222,446,4860,1398,4796,2776,5799,5070,808,1586,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,233,4029,2473,1371,975,5995,3014,1520,5286,766,6249,2632,501,2594,3989,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,176,5719,1230,1215,5996,1215,6564,6568,6570,6571,6576,834,734,1057,2398,2672,3035,1350,1906,6069,1907,971,2329,4005,405,1163,5460,1532,6574,396,1718,6566,6565,6735,6576,6572,4735,2360,1856,6166,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,5576,4046,3241,501,1351,2706,3989,834,2632,1461,3830,6940,2915,455,255,2530,6849,4385,3479,2261,4125,1532,1826,7019,4770,6845,6809,6366,4254,2658,1520,215,4128,2632,501,3241,5799,5070,3936,3964,3989,4061,3100,4656,1461,6743,396,3830,4527,4834,1057,3644,2639,2261,6645,4131,6793,6595,6214,3874,6796,323,5996,7022,1699,1152,7286,7268,6212,1718,6216,6221,3761,7641,6218,6117,2687,6104,1181,6443,5142,4860,6607,6385,1770,1771,1765,1768,1769,1766,8258,5817,3625,3884,766,4109,5576,955,6845,3728,1568,6635,4126,3415,1055,1647,1727,2299,4689,961,3850,4424,6588,1826,1532,734,2398,1371,6215,3896,186,665,1461,5742,223,7635,840,947,1532,3761,3263,8248,8337,8249,1057,2687,8150,8316,8247,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,6,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,11197,11200,11034,11063,10787,10820,4901,10914,1576,11201,11347,11324,1886,958,11130,11402,11278,11488,11376,11117,10039,10494,10885,11115,10687,2266,11495,11449,11497,11455,4154,4520,11782,8937,8299,8144,8516,8468,1385,11272,11234,10720,9277,11776,1453,6350,6162,6588,5996,2576,4218,1181,5091,8143,6122,7995,6941,7840,7787,7879,6726,7548,8032,6971,1313,8093,9078,9047,9092,9074,9085,7795,8903,8526,8836,8230,1181,9321,1057,396,8093,9420,9386,9990,7130,9916,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,8442,4144,8829,6314,6686,2657,8548,4209,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,9430,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,2992,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,10823,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11722,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,546,539,8085,8339,7238,8342,8332,6726,8338,979,7672,8404,3878,7903,730,7143,7546,8615,8586,7870,8584,4432,8460,512,7092,1461,7771,8583,5020,8398,8401,5995,857,7772,8044,8063,1927,5331,1917,1929,7833,3581,8334,7660,1928,7659,1268,4969,3701,3933,6497,2244,5477,1536,7268,3875,4603,8332,4599,542,536,4600,539,5235,4602,6315,8215,529,320,553,3612,8724,3701,544,8275,8946,8343,547,9291,524,9301,9289,9337,4652,7666,7037,1349,8365,9374,8044,9346,8573,739,9248,7270,8805,8934,7913,61,7261,7068,8915,1741,566,1210,1207,7580,7755,5143,5251,7756,8509,28,2677,7554,7927,7879,5995,7548,7878,1461,3754,233,4109,1520,231,1738,1228,1532,186,8222,358,4185,8390,223,2727,4639,8358,6842,6155,2889,8306,6589,8103,6588,8109,6639,8514,6366,567,6726,4131,3754,2706,2029,6178,7992,4796,8222,2989,7995,8816,8910,8230,5996,3604,2253,6971,5247,7878,1738,7304,7607,7719,7920,9051,9116,8999,7016,7839,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,7089,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,7112,1163,7660,8282,8398,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,8966,9092,7781,8479,8836,6381,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,7160,3850,5947,1738,7605,6656,4320,840,8150,9425,8531,8674,6144,7599,3358,6971,8345,6997,650,9602,455,3327,396,4385,6523,6538,6334,9088,9233,9300,9072,5484,8991,4005,178,179,971,9661,2329,1906,752,2709,1163,9897,4710,5460,2889,5460,4005,9875,8923,9878,9956,840,9877,9873,9876,9874,7362,41,9552,8829,9925,5551,7905,3402,7634,3059,1520,8617,8851,4109,4986,567,10116,9808,10048,10245,10283,9420,9831,10128,9780,9668,9913,10273,9602,10127,10284,9456,10265,10173,8948,7833,7903,7143,10233,10246,8953,10302,10531,3457,5516,3523,6867,6874,8193,10554,3889,6534,1257,2573,2183,7840,1345,3830,1126,6122,3302,8306,6660,7757,6658,8613,7833,6506,6533,4218,6715,7903,7143,3216,8514,933,3557,947,5305,5848,3217,6562,7180,3889,6571,4796,6570,1181,6255,3989,1057,501,4901,7184,455,1349,3520,9032,4109,3850,8913,2360,7795,5148,8842,8183,5552,8912,7031,9130,6712,8230,1738,8274,8871,7635,8271,3073,8903,4355,6876,567,1461,3071,9354,6689,9273,9200,9039,9369,7752,7753,9365,8088,8627,9037,8948,8851,9353,8943,8944,7881,146,2473,7234,1038,4735,9371,6684,9614,9773,9772,9767,9900,9386,9525,145,9879,9814,9788,7917,7772,510,9938,9936,2039,10053,9665,10001,2033,9986,5770,9987,9991,10141,9951,5484,9769,4510,8192,10188,5839,10002,8826,4945,4941,10257,9981,9982,10179,10292,311,6512,10208,10173,3883,9618,7299,9832,5454,7986,9812,10116,10368,10146,36,7699,10398,8541,9916,10314,10268,10303,10290,9888,10544,10534,8815,6971,10526,10540,8780,10474,10505,7985,10664,10048,9116,10535,3881,3890,10737,3897,10686,10736,3894,9946,10552,10542,9838,9144,8880,9146,9150,9052,6066,9602,380,8882,9780,681,6539,10048,8878,9950,10098,10047,694,9951,9420,10131,6076,9900,5743,5692,9942,10161,8880,9403,9868,9988,5515,8745,9419,2998,169,10897,8744,8150,10892,8689,9420,9602,10873,9916,9913,5467)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC