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,6104,6809,6845,3162,5996,4049,1453,834,6315,6642,5636,5837,2118,5764,6709,1576,6348,6710,1953,6861,4185,6863,4570,36,6364,6713,4277,6645,2160,3715,5013,6123,1559,4767,4886,739,6981,6842,5997,6994,4131,6740,7238,1127,344,7138,6862,3557,7761,7835,7836,6858,7779,3059,7126,7019,7878,7919,7833,7304,8019,7981,7016,7992,1521,850,7834,7751,8220,3217,8193,3754,7972,7580,2419,6698,6857,7973,6117,6962,8547,4798,8440,4510,252,8355,8353,7541,6984,6127,2023,8356,4617,8807,8827,7970,2183,8306,8305,7860,5739,3823,8997,8543,8910,6968,8681,8933,8355,8698,6174,8948,8353,7974,8356,8817,7032,9258,9222,7928,9223,6412,6967,3595,9009,6175,4806,5602,9223,8222,8793,9195,9925,9290,8290,9888,10039,9926,9835,10212,10229,8169,10127,10355,4128,6130,5893,6157,5070,4659,1381,1402,6103,5542,2137,675,1016,1038,946,5331,1954,6779,2032,2677,1385,5247,6642,1439,6364,4985,3908,6986,7101,5764,7097,4898,5142,7074,7092,7075,1461,1145,6118,7298,7019,4424,7261,7289,7239,7267,7273,7271,7285,5961,501,7158,7272,7208,7036,359,4079,7296,6740,7605,7579,7797,7245,7089,2674,7269,7097,7906,7937,2976,7835,8093,7264,8041,8144,8057,5764,7287,8169,7266,2046,2389,2025,1461,2389,8187,5142,8052,4563,7939,7154,4624,8293,6740,8423,2381,8411,8237,7982,2261,8258,8305,4639,2658,4766,8480,8483,1298,8417,1917,7994,8079,8459,8853,8062,4395,2913,8894,8769,8426,8810,6891,8306,7037,7761,3346,8763,9083,7957,8651,7659,7239,8201,8658,2882,8547,8736,7210,3261,9308,9261,7775,9160,8055,6589,7900,5455,8736,6792,8055,4131,1029,9277,4597,9561,2052,9580,9038,1453,9647,4983,9562,8477,9446,9754,4079,9834,9444,9344,9136,9313,9258,8046,9367,9544,7073,1272,10009,10027,9450,30,10025,9821,9757,665,9316,9594,9954,9530,9257,8711,10056,10123,10261,10274,10125,10297,10144,8472,8019,8052,9575,9161,10512,10535,10353,10364,10182,9999,10356,10451,9370,9091,10541,10570,10694,10693,9158,9509,7261,10767,10039,10145,9259,10582,11134,11230,8062,10476,11116,9594,11337,11371,11671,11542,11651,11654,11225,10399,11476,11538,10401,10030,11767,9999,11805,10814,10582,11802,11794,11890,11754,9259,8740,8424,4234,4131,501,3989,2706,7878,7879,8933,8087,5070,7088,8450,7086,7112,4796,6354,3073,8305,2737,3549,6390,2989,5380,223,1029,5576,7238,7304,6364,2869,6740,961,4294,5297,4395,4293,7593,1272,2605,1461,2706,5386,243,7179,7599,1371,7022,840,1351,7761,1095,4432,7840,1165,7984,6809,1349,4386,7176,8091,4985,4944,8135,7920,4945,4941,4940,4943,4942,4939,675,8358,665,8151,7239,7900,1126,8547,6600,217,8514,501,7241,7187,6953,7261,6570,6644,6104,8825,7665,8783,4834,8626,6595,8142,8488,7910,3029,8781,8305,6499,6204,3549,7636,8019,5121,7994,8638,812,5334,9007,8055,6780,1645,1345,8047,8019,8780,7751,8816,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,2467,8681,9546,9558,9577,9900,6113,9945,9386,10046,9959,10146,10240,9601,10353,10346,10349,10467,10002,9257,258,8269,7659,9277,10060,10892,10814,2399,8471,8092,7900,7283,2913,2761,4765,11272,11271,10287,7874,8033,11333,10715,4218,8305,6780,3549,2388,5334,8019,5582,265,744,3850,2331,4964,4563,4164,4706,239,8995,9300,8628,8097,9647,5729,9864,9838,9897,9900,567,7634,576,7635,9381,10017,10041,10092,9617,10094,1912,2328,1029,1516,2052,5420,10141,6831,6899,1770,2117,1771,1766,6177,4535,9389,9387,6849,4125,9193,9235,10297,4563,10148,9914,4405,5917,9986,5305,933,2261,7299,9105,4947,3522,9126,8706,8560,10259,10535,8019,111,7822,9164,9065,10781,10236,4395,10021,8182,10823,10877,10658,10974,464,10937,9164,9065,10956,4801,3261,1092,5839,9941,10922,10912,10923,739,3850,5331,1433,3368,320,5764,3715,3542,6792,1559,6117,5373,6635,4131,5331,6559,6782,4185,2294,5349,5542,5142,3625,5717,3368,6713,1038,1299,512,2160,5215,511,1521,6315,5020,6639,1347,3037,6693,6595,6548,3080,5339,2933,6858,922,608,6154,24,6700,5247,223,5885,6367,3026,3904,5875,36,5837,6584,30,239,6674,748,1536,1576,736,585,104,510,6713,6560,1253,6792,504,754,3474,6862,3863,2387,768,1067,1113,1347,1872,6793,1523,7138,4028,1526,1569,2381,4194,321,2660,2419,7005,2639,1055,5331,4126,511,4061,6188,2299,1647,5764,3413,1727,5614,5817,4362,6845,955,7358,6809,6104,4923,1568,741,3419,1823,3561,3933,2976,3701,6699,3936,967,5236,2590,7839,4553,7012,1134,7025,7883,784,1920,7759,3117,7780,3134,7840,3129,7876,7760,7712,7859,7879,7821,7858,7855,6981,6315,4624,7865,7856,7719,5543,6734,2882,6697,7920,7896,6679,4258,4460,6986,5545,4566,7126,252,1268,4969,7354,2244,7919,8089,3100,4128,8000,7156,4901,6684,4082,6337,6314,4730,1073,5047,1439,1127,1298,7550,8543,6131,4886,7840,6740,7238,8220,8215,8225,7827,5739,7559,6117,6365,7981,7138,8900,1311,6945,3195,6478,4432,8888,8902,6136,2018,360,1698,8901,3542,7605,8146,1521,156,9036,969,9200,9279,36,9116,739,2387,6792,6713,9329,9244,9372,9322,9374,2944,3542,9273,7580,7138,1349,9258,1215,8306,6337,1521,6942,8925,7038,8681,9018,9051,8698,9050,8687,9109,4023,1432,8031,1257,9406,7005,6663,6664,4652,8514,8795,8805,9363,9454,8910,9402,9391,9333,9421,9335,8978,9346,9366,9308,9197,8934,9248,7839,2514,8817,5180,9041,2841,2246,4679,4504,609,7354,8254,1005,9249,1586,8935,9471,3549,5334,8794,7910,8547,4765,6780,4194,5215,1576,2117,8915,752,2387,8193,8019,254,5516,4538,6684,6642,5121,9459,2709,4405,2669,428,9600,2123,5602,2118,1762,9604,9606,5379,1681,1572,1498,6874,9627,5640,3613,4099,6867,4056,3457,3964,228,8629,1080,9038,3023,9638,2743,162,9455,1121,9634,7581,1119,9335,5046,9653,9657,6663,9635,9383,9677,9665,9345,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,11336,11273,11488,11274,11912,11028,10787,11279,11275,11542,9609,8548,7839,11262,7281,9259,11958,11020,8999,11337,11534,3702,9053,7655,7655,7906,8077,9510,7668,8207,9386,9407,6631,7906,6591,3282,9320,8422,9577,4339,9659,7669,6629,810,6693,9292,5376,7159,1685,8794,9821,2913,9664,9813,9936,3604,8742,1992,2658,9354,9479,1967,9049,9933,9985,9526,9594,9594,754,7765,7880,2253,9198,7783,9161,1185,7572,8816,9275,8055,7675,2615,6715,6723,7589,9134,2753,8305,7840,7879,7878,6712,9321,5576,7879,2869,6122,9039,9449,8850,9116,2164,223,8826,9386,8815,9467,8358,8305,8822,8683,7636,4639,1368,848,9258,812,6663,9308,9879,9606,8494,9884,6113,9772,9825,9969,4144,4663,9730,9963,9612,2253,9883,9900,7900,9967,142,10085,10073,9952,10087,10039,10121,10047,9990,5692,9942,5743,10048,10145,10188,8780,780,7865,2912,772,4109,4982,8845,7758,7864,169,9130,2170,8842,3610,10233,7775,10237,10247,10126,308,10241,10242,10225,5765,5623,2170,6681,10234,10124,10072,10319,3647,10364,10182,9834,8836,10294,3465,10480,10303,10505,10518,10293,10538,9214,10549,10177,10566,10436,10535,969,10656,10714,10611,10751,10711,10665,10697,10777,10672,9919,10541,10780,10712,10715,10663,10871,10866,10892,10699,10904,10905,10868,10786,9257,10912,10467,10830,3159,10935,10988,10934,8913,9987,8912,10141,8842,6599,5707,10832,10781,10893,10658,11010,10398,10820,10807,10023,8076,8077,10588,9225,9247,142,10708,10710,10709,10287,9825,7793,11484,11195,11383,11435,217,7874,10679,10687,2164,11371,8076,7123,8475,11744,11436,11705,8556,11927,11331,11848,162,4598,9527,10042,10003,1349,10063,1134,10149,10057,10062,10048,9937,10144,8514,7138,10227,61,9406,4432,9930,8105,9961,5553,10183,9066,10273,7839,3080,10127,10342,4277,10378,7829,10476,9346,10121,4460,9249,10512,10569,9757,10568,10674,10243,10538,10685,10129,608,10653,1253,10514,10783,10745,10359,10065,10743,10244,9935,9372,10893,10880,10303,10878,10895,145,10113,10683,8999,10740,1347,5903,11027,10341,10719,10739,10744,10748,9725,9454,8935,10871,11126,11123,10114,10719,11100,10476,9983,10893,10895,8557,11172,10747,6699,6635,4460,7017,11272,4061,10355,11220,11340,8010,10977,11237,11353,10856,11285,11287,11349,10543,11361,10528,228,9278,10870,3115,11202,10879,10893,11171,11107,10842,11489,11201,8910,9928,11084,11381,11604,11287,9832,9298,11599,11377,7005,9439,11647,7038,11083,3936,3847,11517,11554,8514,10739,10749,7876,8853,11646,11396,11681,8031,11724,10814,9922,11678,10782,9833,11243,9831,10288,10289,10266,5193,8835,11396,11785,7602,3501,8550,361,10233,8548,252,10039,11670,6874,11021,11377,9677,11875,9600,10359,11784,11423,11717,8105,1347,5688,11822,5545,11703,5193,11235,11443,8915,11702,4652,7593,5917,8935,5817,9799,11965,11873,8805,11874,10396,9634,11871,11783,9363,11964,11991,12001,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,6961,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,9234,4224,9709,7971,9132,8393,1766,1769,1768,1767,1765,6740,446,1345,9569,9622,9158,7659,9621,8477,9622,9660,9563,9745,8769,8399,7869,8288,4512,6642,7241,7272,7286,9813,8475,8049,9562,9767,9770,9247,9888,10040,10272,8059,6324,9093,7774,7989,9771,2342,9609,2967,10630,10689,8151,9319,10696,9647,10451,10741,10656,7289,10441,8202,7671,8358,10679,11441,11225,10692,11331,11533,8050,9748,10274,9773,10273,10629,10869,7962,3823,8087,7081,9647,3549,9389,5334,9387,10259,6780,10655,2913,9872,9963,10056,8305,9258,7130,10212,10712,10714,9295,3046,10724,10738,10342,10702,7882,9063,10763,10734,9868,10111,10364,10649,10786,180,10715,10550,9736,9300,10836,10839,10838,3712,6348,8151,9838,10549,10837,10721,10547,9453,9864,6712,9900,9349,8219,8706,10176,10937,7928,9072,10751,7776,10910,10974,10865,10086,10362,10913,7909,10090,10089,11022,10915,10088,10087,7998,8828,8182,10679,11043,10818,9090,7910,6602,5435,4923,10248,207,7696,8432,11052,51,9970,9906,11238,11294,7986,527,3877,6806,9520,11310,11297,4512,11319,11356,11355,11357,8219,2009,9543,9134,7671,9647,10272,1461,10532,9453,8240,10229,10274,1237,10548,9745,6261,180,10024,9675,3059,10528,6983,10733,10362,7064,10914,10904,5252,9554,8925,11027,10114,9373,9045,10938,5764,107,11123,11105,10127,11020,10904,11044,10870,11180,11136,9325,11136,9991,10935,9374,8557,10148,8093,11338,11339,36,11262,10934,2160,10048,11353,11442,10469,11172,10685,11289,11436,10467,3613,10738,9471,9942,9945,3159,5692,10129,11423,10915,11202,10312,10733,11439,11388,10719,10244,11620,11669,11377,11288,7910,11271,11018,7362,9352,9290,11658,11717,11455,2590,9081,10938,9050,3396,3368,4131,11492,11717,10554,24,10832,11775,9353,11787,11703,11681,11838,9221,11819,11598,30,11736,9554,7036,11670,3376,11822,11647,11554,10375,11135,10011,10410,9530,9594,8208,7086,947,173,8894,8554,223,6981,8305,9647,7938,2766,10937,10649,217,3549,4765,6780,10910,5334,10093,11272,1998,7149,11408,11352,5988,450,11129,10454,7792,10937,4405,9116,239,2490,8095,6119,10955,2063,10285,10092,10093,4144,8922,8628,10165,10133,10786,10552,10287,9547,10913,10286,8952,130,8995,2469,144,8008,2653,3304,4722,10702,2671,9349,10626,10830,3165,2467,6325,8870,8844,2454,9828,10805,2753,3908,4659,10257,9767,8995,10165,2490,3590,10865,8933,10836,3465,10241,2334,4164,5839,3646,7234,9983,9864,1185,3282,10715,6780,3549,4423,11271,2253,8706,311,11435,10260,11453,7785,7586,11134,11383,2628,8304,11302,3415,10714,8169,9895,1232,665,9538,11669,1052,11609,7824,11382,7777,2658,9014,9354,11272,2934,9281,1593,11620,9473,12011,9647,9078,1755,5623,11228,8010,11353,1234,1210,1207,1198,1145,1056,956,947,923,57,28,10823,3014,2995,2776,2725,2736,2677,2451,1741,1533,1425,1398,1370,9675,173,9418,4731,4519,3564,4600,4602,4603,4599,10454,10447,3189,10448,1616,566,466,9533,11655,11646,11719,11724,10278,11691,11741,9148,11645,11187,11509,11681,11647,30,24,10689,11785,11361,11703,11783,11787,11842,5193,11718,10904,10964,6874,11018,11834,11838,8305,6780,4708,5334,8019,10892,4765,3549,9647,11906,11822,11287,1698,9928,10719,9922,11599,11900,11869,11871,11982,8172,9492,11845,11874,11921,11457,10832,9929,11423,11134,10784,11454,9634,7719,10019,11679,2761,11315,7592,9767,3493,7554,7755,7756,7754,8509,7927,8922,178,177,179,6117,3549,8305,6857,5334,11271,7581,6780,8543,9648,9347,9798,10149,10476,11423,11142,10878,11645,11816,6315,4316,4512,5003,9045,5541,11990,4432,8615,168,6002,11703) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC