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,1439,6793,743,5088,7290,6901,2863,4217,7047,7837,7275,1895,2677,6902,5623,4432,1954,3590,6901,1826,6553,419,7063,2677,7029,341,6860,2956,3760,7879,7840,341,8502,6718,7674,8171,8436,470,8587,8488,8095,8616,8094,8587,8886,2956,3788,6562,6563,2334,5222,3417,3282,743,9002,8997,8993,8994,9003,9001,7233,6990,7783,7029,8617,1416,8870,5765,1577,2889,3029,2766,6824,5692,2331,7034,9002,8587,8993,2957,6790,8004,3590,9321,6780,1568,7712,6902,7029,8488,8095,8780,7619,3564,1131,444,2331,2334,2592,955,9390,2956,2446,9363,1834,971,3418,3479,8923,1893,9463,7787,2454,9511,9512,9531,9532,9528,9551,9568,9571,9570,9566,9002,9001,8094,8095,7000,9531,9419,1532,9321,8996,8094,8834,2680,9783,1163,7618,6882,2698,9982,10005,10004,10012,10013,10014,10017,10015,4422,7907,10019,6828,10109,10110,9947,9982,10108,9948,10118,10165,10112,7830,9570,9226,8845,8461,7674,6556,6557,7618,926,6095,2923,6551,6555,1278,1815,6068,5856,9987,10267,10221,7792,6205,9987,10413,10414,9620,9619,8083,8034,5066,3358,7605,10397,2329,9532,10345,6555,6551,6248,6552,7829,10266,10141,10127,10632,10635,10395,10266,10621,10620,10619,773,9200,9116,8978,9290,6635,9798,8431,9650,7272,9742,10571,10574,10585,10772,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,8962,665,2998,8999,8182,4901,8306,1245,8141,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10355,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,11304,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,11457,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,8134,8936,8979,9543,3891,3892,7986,3896,3890,3884,6493,3889,8271,4659,8144,1738,5995,5543,5373,5339,5349,5251,947,947,1349,228,6559,1038,4395,1461,8089,9526,9527,9811,1215,5995,1257,8306,9831,9569,9551,9566,2331,10020,6571,9982,10081,10093,10088,10087,10090,10080,10092,9991,9890,9222,10165,9921,9913,10128,7803,9570,10002,8252,7029,6901,10288,6902,10413,9528,90,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,9371,6684,9614,9773,9772,9767,9900,9386,9525,145,9879,9814,9788,7917,7772,510,5362,9938,9936,2039,10053,9665,10001,2033,9986,5770,9987,9991,10141,9951,5484,9769,4510,8192,10188,5839,10002,8826,4945,4941,10257,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,7222,9270,10086,10094,10056,5170,3904,6354,3073,2698,3070,10134,9603,9475,2271,986,3351,3429,5631,10132,10133,2707,1159,4901,5837,10210,10018,780,743,772,4406,10277,5131,4653,10285,10286,802,1441,1160,1110,10205,3825,10287,7758,7858,6852,7865,9353,7864,1915,2654,1277,9607,732,10207,10241,10242,10104,7856,7855,7221,3731,10130,10209,10148,10344,10345,2912,10374,8946,10376,8919,10358,6902,141,10243,10373,6163,10065,9406,9511,3731,8910,8095,10416,10543,10400,9910,8813,10399,8812,9252,10401,10479,6901,9929,10120,9937,10362,10476,10530,9769,10046,10660,10661,10662,10112,9386,10633,9748,10119,10118,9761,4240,802,5321,2657,10709,10708,8687,10710,9253,9251,1835,1190,1177,9466,8387,1176,7554,7754,7755,7756,7927,8509,10528,10062,9770,9222,9253,9251,10787,10857,10523,10395,10836,10814,10870,10396,10358,10569,9614,10632,10244,10634,10917,10918,10568,10635,10584,10583,10636,7029,10919,2912,7674,141,3351,7856,9512,9531,9532,2658,9551,9566,9569,9570,4199,9568,11028,8615,9528,4624,4730,8902,446,10212,10895,8888,8278,8276,8275,10657,10913,10911,8799,9987,10141,7221,10205,10207,9277,3428,7239,10066,10165,10236,9402,8031,1253,5545,10413,4969,9454,11027,10414,7636,8095,608,1368,10549,10837,848,10512,7580,4766,9391,9982,4233,9571,8252,3100,10649,11112,6163,11141,8842,5013,5154,10113,10114,8629,8837,3029,228,10063,11142,9904,10967,11102,9543,217,10087,11219,11126,10938,11217,4337,6863,11202,11122,11220,11100,11084,11123,28,11106,11268,9638,7550,10397,11180,4984,645,1917,9950,11219,10784,661,10127,744,6731,57,467,1092,89,4785,4536,2873,11374,2871,6730,4329,6692,4882,6776,3100,2317,6185,11330,5131,4406,11228,4046,4048,4045,10377,8147,7057,7857,7003,6736,4049,4050,6741,2033,8517,6705,4136,7016,9251,8812,8813,9252,9464,11302,11235,2639,7870,8586,9147,9920,8682,9407,10565,3874,7986,9154,11019,4146,11493,11339,10893,11611,4714,11255,8662,11218,4464,5066,4512,4470,7167,4463,7165,6354,3073,3071,6689,7753,10489,7752,7167,8088,8627,9037,10053,10544,10975,11221,9383,9867,10232,8946,6538,6537,6536,6535,8943,6534,7881,8944,7179,7178,6506,10733,4785,11722,11836,7569,151,11252,11231,11179,4599,4598,11899,10155,8432,4598,10610,10448,11016,6929,6377,11358,10622,10599,5635,8965) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC