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,5070,808,1586,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,233,4029,2473,1371,975,5995,5362,3014,1520,5286,766,6249,2632,501,2594,3989,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,215,4128,2632,501,3241,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,5362,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,2029,5148,6971,1257,5576,5995,6831,6940,3989,1215,3830,2869,1351,834,6710,2033,4223,4860,501,2932,1461,766,4798,5070,585,1690,4796,1038,3989,3037,2706,3904,6863,6693,3595,4061,5148,4969,2632,2261,4234,5995,1325,3830,1215,1257,3241,4209,4656,5179,3080,5286,2657,739,36,6779,6679,4886,3964,504,446,228,5543,2976,3493,5331,2294,7143,608,6858,6595,1699,5795,7126,4258,1137,5817,1253,7709,5545,4460,997,5339,4178,3059,3080,4635,2933,1347,6981,5207,5142,3775,7019,6632,5193,3525,6986,1917,4566,748,1347,3100,233,7582,6842,3542,7761,5373,2337,7883,2894,6010,6713,4131,7920,1521,7759,7839,1369,215,2658,969,2025,802,7238,8193,6740,5236,4987,8548,5996,6713,7138,7760,7123,6209,7097,7101,7115,4724,2023,5732,1490,946,4234,5148,2632,3241,501,5179,766,640,7940,7943,7093,8064,7084,7946,1038,6981,7931,8393,8391,7941,9634,9648,7581,9347,6117,8543,9798,9930,9932,9929,6857,6857,9637,9961,10784,10476,10149,10878,1327,7143,7143,1738,3582,6642,7837,7837,6103,6103,4860,5995,5995,8109,3647,3647,2029,2029,7995,4395,4395,7037,7239,867,867,867,1645,2006,1215,2041,2041,6971,6971,8230,8143,2729,2729,2729,3913,2992,9306,9976,9976,9976,9976,9976,2261,6740,7238,7840,8220,7879,8094,7878,8617,7634,4109,8358,8183,8629,3066,1298,4648,5739,8745,8744,30,8146,8514,5070,1439,6842,8488,8095,8826,2632,8834,7920,8816,8616,7781,2766,972,8089,4082,5373,6713,5142,1521,3542,3715,7920,3625,3413,8852,7550,8888,1349,4005,6200,840,8886,1371,6103,4395,5995,6740,7238,7283,7641,7238,834,1371,933,3302,2530,2183,2594,6842,8142,7635,567,1070,2632,8306,8306,223,2876,2033,4861,5070,2932,2706,4860,766,5179,5148,7020,7635,4109,567,4986,8617,8845,2889,5551,446,7634,8358,3216,2594,3241,1126,7840,7689,7223,4791,566,4861,3048,8251,2700,947,4234,7047,6249,1954,9300,3860,6255,4234,8142,5995,4362,3860,4406,9321,4406,9321,2635,7953,2706,6259,1894,8222,7641,4325,3029,6618,3744,5484,1609,322,8434,8628,6256,5669,7635,5693,4349,5854,2033,6252,4109,1954,6248,1954,6248,8798,2925,9476,9052,5179,5148,4861,5070,4860,4234,3989,3241,2706,3830,2632,766,734,6256,5401,2049,4598,5063,3358,5065,5052,5053,6252,6255,1815,5854,5870,1278,1816,6068,1894,6248,2019,1895,2247,6251,2245,2330,2509,2678,2680,2681,2703,90,419,1506,5669,5726,5856,5368,5445,5428,6250,5565,4451,5070,3989,3743,3516,2923,2033,8798,3830,7618,6095,7617,6249,4204,3829,5157,3516,6254,6256,2918,2923,3743,4340,1650,5865,5693,5468,5242,5573,501,2594,926,6245,9052,2033,1650,6243,501,5179,8893,4535,1095,7773,4395,5996,3428,4395,2932,4209,4079,8902,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,5419,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,11028,10020,9780,10569,7614,7615,7550,6713,8837,4082,7017,8888,11237,9454,8925,11488,2706,10856,11349,5373,252,3542,1521,9220,10375,11593,9904,5739,9374,9615,4455,4739,10857,4455,4739,10857,1490,640,4411,2023,9987,779,11644,10798,10300,8049,7906,10342,10530,11595,11678,11594,8548,9850,9348,6557,6961,739,11492,1127,10131,10861,8893,9212,6876,28,10548,3595,10278,2776,11089,5431,180,1461,148,3059,4798,10798,10870,1917,9951,7998,10895,10273,1769,10894,6010,2594,8893,10823,6983,10745,10569,11028,8900,5142,5373,8585,4730,6315,1690,9376,9376,9137,5454,8520,5763,7099,979,8583,7808,9407,9638,9634,8584,8824,7631,9493,9591,9590,9084,7546,6201,9588,9587,9149,9593,8596,9535,8325,9665,9589,9430,8782,9429,8324,9637,5321,8323,9867,9725,8358,9920,8583,9407,9084,8585,7546,3898,8682,3898,10053,7870,9921,1038,3542,1521,10055,4136,6824,9811,5995,10232,10090,10087,2160,10080,10238,7016,10182,10112,4624,585,2025,3288,3904,10342,10523,10479,3159,5692,10548,9808,5743,9471,10048,10212,1770,1765,10212,9942,1767,10719,1769,6354,3070,3073,3071,6689,7753,7752,10674,9212,8088,8627,9037,9665,10053,10544,6688,10975,8943,10894,11142,9798,11221,107,4082,11423,11020,9477,8943,10672,11288,11310,10673,11550,6354,11644,11748,11670,10892,5995,8306,1257,180,4739,9900,10212,9116,10002,9600,4861,9220,2261,10737,3287,10526,11324,2632,2033,3493,9052,7938,11020,10735,3134,11105,9116,10892,10039,4028,6874,9352,766,2033,4234,4796,8933,9455,768,9453,9836,9052,741,8923,5148,5070,4861,2594,2706,6010,766,2033,501,4234,4796,2632,2932,8172,5179,10179,5986,3989,11474,6133,11637,5179,10892,8306,8514,11670,9258,8388,2261,4639,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,8048,8041,7261,9930,9929,9921,4798,7068,8071,8439,8368,9461,9931,10244,10227,9817,4178,9543,10476,10149,9961,7086,8837,8793,446,9661,9195,5995,9160,7258,1349,11028,1350,9542,10063,2594,11021,11219,766,1215,6842,1257,2706,2033,2632,9453,2932,501,10375,4234,5148,3989,4796,5070,10878,9648,9634,6117)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC