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,7480,7409,7078,7516,6408,1242,4227,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6003,6104,6691,3860,6104,4985,2467,3549,4395,1302,1302,1302,1302,1302,1302,9815,10615,979,9136,8228,6586,2605,10302,7650,9148,7272,3874,7246,7246,7125,1993,9204,7110,9797,9563,7111,7420,7486,7431,7506,8865,8864,8867,8867,8868,7437,7334,8496,7159,7385,7501,7484,9024,9024,9024,8650,6809,4046,3830,7285,6115,7561,7561,7561,7561,4362,4362,7427,1215,4046,5912,3702,3850,8027,8222,778,6855,6855,7561,7561,4050,3162,1073,1073,7485,7485,7484,7484,7484,7484,7484,7484,7484,7484,7484,7484,8280,6766,7160,4320,4535,4535,7833,7833,6971,7833,840,840,6715,6715,4500,4500,8863,9030,9030,7833,2729,8947,8947,3327,3327,3327,3338,9830,9830,9830,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,7869,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,8269,7660,8388,8441,8489,8526,6971,8611,7071,7258,8687,3368,8739,8734,8699,2590,2419,7585,7585,8193,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,840,840,840,9853,9853,9853,9853,9853,8477,1765,7390,7390,1770,7288,9022,7563,6778,8175,9880,8867,9554,6579,9991,1085,7446,9022,7560,4918,6195,7849,8130,7387,4401,7437,9090,8497,7390,8389,4316,4512,7422,2520,6715,8290,1970,9361,6700,6383,7493,7521,5923,7499,4742,7272,7368,7501,7122,8406,8406,7105,7304,5897,2041,10572,10572,10211,10211,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7539,7539,7539,7539,7539,7539,7539,7539,7539,7539,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,1307,1307,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8468,8892,8468,10026,9189,8425,8386,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,11711,10400,11711,3860,7516,8925,8901,8947,1349,7920,7037,8837,156,6266,4805,9033,1738,2467,9038,6986,8089,8884,320,36,1349,6569,7647,2989,3719,9196,665,4395,9249,3142,446,6266,1439,3523,6863,5331,9195,8915,7019,9464,1215,5732,9376,36,8089,9553,9556,9557,254,9526,6845,1461,8934,4947,4769,9637,9372,24,104,9639,5142,206,9648,9654,9641,9750,458,947,9824,9779,9930,9543,9926,9363,162,30,145,739,9937,9340,9972,9965,9221,6986,10062,4156,10057,10063,1325,608,7602,9553,9638,10149,93,9764,10042,6798,9635,2976,3878,1559,8358,2594,220,10212,6632,6104,6261,446,1299,7138,7036,10258,10244,36,228,6117,6163,61,10267,501,93,10300,9335,9754,6858,5148,9811,10182,9638,4056,1347,9764,10243,9220,10227,9052,5267,10476,10350,7017,10341,10416,9476,41,10396,10315,10541,10530,10543,9807,10568,308,8999,10127,9249,10548,10657,8615,10548,10608,10523,10622,10569,10652,5795,9107,10528,10663,9937,5513,739,61,10780,10719,10375,1127,1257,10784,10787,10749,10870,228,10893,9798,10894,10669,6696,8193,10895,10672,10878,10737,10870,9353,10798,10883,11021,2706,11028,10856,10964,11041,10879,10784,10871,10748,11027,10373,9406,1047,252,10683,10764,10512,11123,11106,11126,6113,11018,3532,10667,11122,11197,11235,11135,11219,11234,11129,11180,11199,11281,11220,11041,11287,11142,11171,11200,11340,11105,11324,10744,11330,10754,11104,11361,11201,11377,10747,10566,11353,11227,11107,9935,10783,9910,11234,11349,11288,11455,11127,11492,11495,11266,10910,7810,5997,11478,11442,11494,11488,585,11395,115,11489,6696,180,9248,8934,11593,10747,10892,11134,156,3523,11599,6696,739,11324,11647,11491,11396,11646,10246,7761,11670,11644,11550,11689,11594,10065,162,11491,9402,11658,11455,10548,11309,11594,11180,4258,10798,11646,11613,8031,8869,11235,10568,9749,1298,4969,11480,10917,10126,11477,11783,11787,7995,57,10531,11479,2590,10919,11606,10002,11644,5046,4325,7017,11827,10917,11834,228,11871,11838,11764,11819,11835,11849,11872,3904,1253,10065,28,30,11495,10892,10314,9648,11847,11871,11869,11900,11904,11921,11848,7839,11342,1176,10091,11235,1699,9769,11725,11498,7883,2933,11964,7126,779,11020,2615,11495,10358,11873,11784,8864,8864,8864,8864,385,8882,380,8878,378,8329,6204,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,381,9899,10054,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,7026,10235,6925,6926,6922,4227,3840,9899,653,10339,4419,10169,11284,11299,6935,858,11238,4226,11410,857,8389,9767,3327,8596,9899,9899,9899,9899,9899,7421,7420,7416,7389,7387,7528,7412,7541,7445,9853,7539,11281,9832,8306,51,4178,5435,5995,10212,9300,4987,6740,7238,10649,9951,9386,10505,10826,10909,10676,10742,10802,6613,11752,10579,11238,11885,11101,10599,10983)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC