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,808,6595,6751,341,6104,1297,6644,344,2518,2974,5996,3359,2151,2933,3080,176,6984,6633,2261,5331,3647,1461,4452,222,5998,4199,5717,6439,2706,4947,1439,4602,4156,4860,3883,3884,4301,3885,4297,3896,3893,3889,3897,3891,3892,3895,3890,3882,1245,1303,3895,3888,6966,6493,4386,6414,6964,4290,550,549,548,539,537,2473,6570,1537,6901,546,501,2605,5454,979,1730,2951,2301,6503,4292,4293,6519,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,6197,4292,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,540,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6656,6652,3879,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8599,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,4301,4299,4305,4302,4287,4294,4296,4300,4293,7963,4289,4304,3515,7697,7694,7695,7696,1704,7608,7610,6548,5691,7695,3442,6303,7677,7168,7167,7170,7165,7163,7173,1779,6286,7164,7174,7169,7172,7693,7166,7171,4463,4470,4464,4486,4473,1571,2824,2780,2785,2795,2783,2778,2779,2781,2782,2784,2789,2787,2794,2791,2802,2801,2806,2805,2786,2808,2811,2812,2799,2815,2816,2817,2818,2820,6489,6443,2821,2822,2823,2826,2827,2828,6442,2825,1411,810,1349,6200,8935,6198,4282,9197,4304,4297,4287,7697,7694,7695,7868,6212,6526,7693,6521,6520,4652,4386,6654,7182,8896,7189,7185,7178,7179,6652,7184,7181,7183,8897,7188,6653,7176,6214,7180,6497,6499,6216,6501,6498,6222,6218,6215,6220,6221,6212,6223,6511,6531,7845,7844,6510,6509,6508,6513,6514,6515,1165,6507,7843,1266,1685,5297,1349,9248,1767,1768,1765,1769,7170,7172,7174,7173,4473,7165,7164,7167,7187,6512,3073,6354,3071,6689,3070,6688,7753,7752,8088,8627,9037,8946,7186,7166,9383,9867,8943,8944,8945,7881,7599,9679,1368,7636,848,4121,5064,5053,1765,1770,9911,9912,7972,7751,7973,8276,8275,8278,8888,8728,9343,9722,9721,9720,9723,8816,8946,9669,3359,2951,9030,9986,10064,9879,10045,9492,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,9632,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,8323,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,848,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,7568,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,10443,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,8340,7194,6386,7196,6191,9111,8599,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9425,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,6139,9500,9183,9535,6371,9590,381,9591,8333,3883,9588,3891,3882,3884,3892,3881,6526,3890,3896,3893,9587,3894,8168,8597,8323,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,10644,8887,5863,6820,6727,10874,10962,11073,6214,4299,4293,4287,9726,5718,1616,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,6197,10522,10534,10436,10502,9632,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10424,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,8563,3897,10102,9114,8331,8336,8529,8335,8530,10322,8832,365,3893,10334,10335,9633,10100,9632,10607,8307,8273,9411,6199,10153,9631,10332,6200,10152,6197,3897,6198,8274,4304,3884,4305,3889,3891,4292,8272,4286,3896,4300,4298,2520,3895,2522,4299,9483,3888,3889,4293,3881,7963,3885,4294,3894,4297,3892,4287,3883,6493,9192,3887,9409,6538,9182,6537,8334,6536,8874,6534,8599,6506,8329,6505,8699,6533,8700,6532,6359,810,1765,7808,1770,1771,1767,1769,10799,1768,10551,1766,10336,10101,9418,9412,10102,9533,3872,8586,9535,10200,10139,10201,10197,10215,1768,8387,381,380,10199,375,7188,394,372,376,10217,176,9430,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,11109,10928,10927,7676,11082,10931,8681,6221,8698,6223,10330,10555,10330,10559,9535,10336,10336,10801,10728,10800,10727,10558,10335,8589,2820,2828,7987,7986,7568,10448,6740,7238,8220,9742,10229,2736,10274,10630,10270,1770,1765,1771,1767,8060,4302,1769,4305,9588,11155,1768,11158,9587,1766,10561,1967,9880,9483,4301,10941,4304,4287,11159,8192,4293,4299,7782,8714,10840,2520,4286,4289,4292,11185,10045,4294,11269,10044,4296,11406,11405,11295,8596,9590,11407,11030,11031,8087,4304,4300,4298,11464,7188,11419,9132,7870,8584,9148,7631,11509,10623,11187,9259,6376,6989,6517,6234,10426,6271,2720,726,4282,4286,4305,4302,6505,2720,4296,4304,4300,11016,9137,7608,7697,10821,10822,4282,4305,4286,4292,4299,4300,4287,4301,4289,4294,1704,4296,7696,10238,4293,11050,7179,8682,9418,9149,4297,6354,11242,8307,4294,4301,3897,3073,3070,3071,6689,7172,3889,4304,3898,11421,7987,1589,6688,8727,4294,9679,3888,9665,8088,10067,8704,8627,10888,9037,10506,9626,4923,4178,9300,10836,4296,4304,4292,4289,4286,4300,4298,11497,9483,4299,4301,4299,9601,4297,8232,2520,1765,1770,1769,1768,4714,10444,11254,11299,11050,10323,8980,6745,10555,11149,10325,10327,10328,10329,10330,10331,10333,10324,6216,6222,6220,6501,6499,6214,6221,6218,6496,6498,6497,7698,6223,6200,9633,11238,4305,4296,4304,4289,4292,4300,4298,9483,4293,4294,4297,4301,4287,7753,4299,8088,7752,8627,9037,11185,9665,10053,10544,10975,11221,6688,8727,8946,9383,9867,10232,8943,11836,7753,7752,8946,8627,9037,8324,4305,10565,9920,4296,7646,3883,8323,9591,8771,4304,8325,9794,9590)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC