this

MySQL returned error




Error Description :
Error No : 1064
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

SQL Query
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,6548,778,6004,9300,6715,8922,9296,1927,6151,8840,8214,6700,8699,6286,1782,1774,1782,1774,1782,1774,6611,7893,842,4405,1927,4706,4224,120,9970,6584,28,1768,6410,10043,6410,10043,6410,10043,6410,10043,6410,10043,9999,10000,10154,10155,10155,10155,10155,10155,10155,4847,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,6821,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,4278,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,10053,10072,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,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,4278,1215,6560,3702,6588,3037,6732,252,3625,2337,1955,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,4879,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,5362,6971,8555,6712,8809,2381,8938,256,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,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,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,5362,9938,9936,2039,10053,9665,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,3913,4178,10035,10115,10047,2261,5269,10042,10048,10568,10533,1385,895,10192,5544,9900,9951,9951,9951,9951,947,947,5402,6832,6691,8968,2328,5371,1521,6645,5582,3346,850,4362,6831,1371,5996,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,3081,10313,6130,10312,6889,1453,8828,3159,5020,5817,7920,6785,8305,1349,6901,7037,6848,5903,9258,7919,3216,1834,1830,1110,986,4131,780,772,6679,6001,5764,6971,743,9063,5011,7143,4617,9837,9541,9471,5142,7856,7758,9924,9928,30,9929,9937,4109,8142,9831,8813,9783,7221,6397,5328,1313,9963,5544,4164,1707,1237,9916,9769,9222,6599,10088,10090,8912,10087,9990,7893,3346,9941,3787,3657,2446,10165,836,3287,10350,9607,10148,10132,10315,10342,10134,10526,6691,6986,4019,7251,7839,7920,8288,7671,8409,4258,3542,8306,8201,8408,8401,8765,7654,3921,7875,1461,8782,1347,8832,6740,8999,7238,8220,4455,3976,4088,8869,9300,7675,9453,7243,9454,9148,4670,9464,9300,7115,8450,7671,8463,368,365,9957,9302,7833,7903,8948,10056,7143,8973,8240,608,9744,9748,9745,9259,8832,9638,10146,10265,10543,9746,3830,4796,5236,455,464,4234,4128,4178,5279,4879,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,4888,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,513,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,256,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,9602,9916,10469,10127,576,10292,10500,10375,9513) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC