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,4178,222,446,4860,1398,4796,2776,5799,5070,808,1586,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,233,4029,2473,1371,975,5995,5362,3014,1520,5286,766,6249,2632,501,2594,3989,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,2706,6642,5484,3936,311,4639,4570,5995,4985,5246,4082,4566,51,2473,2288,3425,7304,6783,3241,6586,1173,1038,1586,6716,6584,6408,6407,4227,6817,1793,5981,6100,5331,5371,7012,2869,1351,5576,4199,4659,2627,5936,6146,585,2025,3066,6778,6778,8050,7250,7654,7297,8251,8443,3250,7069,7374,9030,2257,8063,7123,7895,8639,7895,7260,7260,8034,8034,8055,7100,7286,7121,9931,8199,7084,7084,735,1257,6792,6709,5995,4178,6713,6589,6639,6593,4234,501,4234,2474,6710,2033,4223,4860,501,1461,766,4798,5070,585,1690,4796,1038,3989,3037,2706,3904,6863,6693,3595,4061,5148,4969,2632,2261,4234,5995,1325,3830,1215,5799,1257,3241,4209,4656,5179,3080,5286,2657,739,36,6779,6679,4886,3964,504,446,228,5543,2976,3493,5331,2294,7143,608,6858,6595,1699,5795,7126,4258,1137,5817,1253,7709,5545,4460,997,5339,4178,3059,3080,4635,2933,1347,6981,5207,5142,3775,7019,6632,5193,3525,6986,1917,4566,748,1347,3100,233,7582,6842,3542,7761,5373,2337,7883,2894,6010,6713,4131,7920,1521,7759,7839,1369,215,2658,969,2025,802,7238,8193,6740,5236,4987,8548,5996,6713,7138,7760,5305,1038,6669,5647,6998,5995,4796,5148,5995,1351,975,2869,5735,943,6663,4128,2469,1822,2390,7034,1520,6827,3181,1829,7233,3302,3778,2331,7001,4947,3843,7787,1245,2571,2635,7160,6104,7794,3384,6845,6858,7594,4555,5719,1070,3522,7904,6898,7304,242,3380,6843,3702,6809,2753,7158,1516,6785,2328,6941,6001,5995,3550,2389,1029,6947,308,4337,217,4639,4769,7101,3261,7548,5421,1351,6740,5576,834,3197,7022,7238,4109,1461,223,501,5454,308,6780,4701,7837,7903,7835,7775,7836,7761,7827,7938,2658,3549,5334,3698,7838,3647,8222,1662,7019,223,3346,358,3754,4535,7239,8390,2029,5763,8547,8611,2006,6365,3554,8358,8561,9300,9297,9880,5719,8828,8768,10008,1766,1768,1351,5996,3860,6366,6725,7840,6189,7570,7762,3913,6726,8109,2889,7635,8142,5551,4986,8390,7635,7020,8297,7840,8109,3029,7879,1770,1765,8815,8730,8183,9030,1215,6139,4437,6122,5421,4218,5770,5371,5576,1462,2342,1343,4570,3863,2455,1461,5576,2269,7307,6981,2869,6809,1351,4535,6809,7020,834,501,7020,5657,3850,6709,2269,1764,7359,4446,934,7546,1038,6599,698,4566,452,3492,6845,6721,156,1271,6723,446,5419,7604,924,5647,1973,4178,1200,4362,5148,766,4860,2006,7160,7631,1993,3830,1439,4901,713,5995,1453,4796,6367,6103,5837,754,2029,5269,7840,6168,5376,6981,7592,6740,7554,7833,6155,7754,1345,7751,7756,6131,5484,6849,6192,4860,732,6940,3830,4796,5236,455,464,4234,4128,4178,5279,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,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,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,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,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,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,7883,7647,2989,1521,1954,2164,1559,4050,4082,3625,2160,2976,4218,5247,2706,7835,7837,3142,3244,1163,405,8030,1718,1738,8182,8146,3479,4983,7654,5763,8150,8103,7761,1038,5732,1569,4452,7158,504,8222,8378,8371,396,1350,1521,4082,6069,1906,975,1826,8089,8281,2381,2329,1907,8290,4834,4131,3003,8142,739,3288,2985,4710,6880,8547,6255,6855,2164,971,8721,8628,8629,4005,1920,1954,8492,1830,3744,768,322,4217,1134,2863,4325,2054,741,8763,5373,7594,252,2989,8890,8851,3625,4109,3715,2337,8901,5839,8089,8904,8936,8925,3195,6707,8134,8932,2934,2294,8933,1052,9009,9086,8871,5997,7981,4624,2946,9196,4767,1190,3026,2054,4240,9197,9249,8978,8795,8805,9220,8087,7121,8045,971,9135,9373,9366,9335,4136,8919,7138,5460,9466,9478,9477,9322,9455,8914,9539,9557,9578,9471,9464,4800,9353,9547,9607,9200,9332,9543,9654,7213,9333,9637,9680,9799,9798,9764,9769,3849,7640,9910,9904,9913,9914,162,9766,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,8739,501,6158,5070,1461,675,4801,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,6740,3830,1029,223,1183,1645,2615,4898,2182,7210,8220,2063,5959,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,566,550,1533,923,7238,6740,466,4788,2736,2995,3564,1370,1917,4645,4785,1145,5988,788,7121,7097,6659,3392,2915,7245,7108,1520,3059,2261,3493,3595,7019,4947,7761,179,1461,6710,7008,2986,4234,6642,1327,721,8085,2775,2776,1886,1207,2725,8222,7019,1198,435,5251,5143,8185,8185,8434,2451,233,501,4861,1425,4512,4316,5298,5298,5003,737,4037,8470,8685,7808,2605,2605,3989,6382,4038,3841,6144,7244,6149,378,979,7285,8793,8340,8246,8325,2520,947,7359,1126,8241,9030,8424,8204,8334,8568,6082,8874,7998,7999,8328,1173,8141,3169,842,217,698,9182,3389,6774,6774,9204,4240,9056,8445,7675,7087,182,7116,4301,4301,9053,6042,545,539,537,7986,7654,7125,7985,543,7999,9870,2677,9533,4784,7117,9418,9554,9676,1234,956,1210,1741,542,9378,1768,28,4029,3014,3891,3895,6493,3803,9878,9877,9874,9875,8459,8469,10171,10171,10187,8446,8445,10272,8363,8423,8891,8892,9082,10399,10451,9207,10011,10400,9224,10706,10759,9649,10702,10401,1257,9674,9401,9297,4401,9968,10938,10802,10991,6342,7852,8963,11089,8437,10667,10888,10887,11188,11402,7080,7661,11370,7655,10768,7655,8721,8737,9658,9199,8712,7933,9398,11189,5995,6740,7238,7283,7641,7238,834,1371,933,3302,2530,2183,2594,6842,8142,7635,567,1070,2632,8306,8306,223,2876,2033,4861,5070,2706,4860,766,5179,5148,7020,5799,7635,4109,567,4986,8617,8845,2889,5551,446,7634,8358,3216,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,2033,5770,501,4861,6004,4178,8913,8912,5070,9030,3850,4029,8933,6843,6122,7928,7354,1461,9052,5070,8089,6740,7238,8220,3702,9879,9116,9939,4860,9939,217,9242,9896,10002,4178,9600,4406,10047,9983,9983,9983,9471,2261,2776,8514,4349,8910,8382,8377,1807,4346,3989,8683,8547,8547,8547,4535,1095,7773,4395,5996,3428,4395,4209,4079,8902,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,5419,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,5799,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,11028,10020,9780,10569,7614,7615,7550,6713,8837,4082,7017,8888,11237,9454,8925,11488,2706,10856,11349,5373,252,3542,1521,9220,10375,11593,9904,5739,9374,9615,4455,4739,10857,4455,4739,10857,1490,640,4411,2023,9987,779,11644,10798,10300,8049,7906,10342,10530,11595,11678,11594,8548,9850,9348,6557,6961,739,11492,1127,10131,6004,6235,1151,4742,5279,2033,744,2658,3368,5148,7833,5251,5576,4701,9221,8303,4395,6740,4395,6740,4566,7238,9706,8220,9698,180,9715,4860,9708,7758,8031,36,8901,9365,9402,5236,8089,9464,9617,9038,9541,9615,9925,9668,9345,9366,9648,9052,2135,1738,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,8358,223,7374,9125,5484,8780,6891,3949,8255,6642,9340,6367,4801,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,3428,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,10528,766,7019,7761,8222,4635,10228,9463,8793,4178,5148,9897,9195,4796,9892,9552,5995,2033,9925,2605,9987,10044,10894,11238,6740,979,10877,9942,7238,10432,735,6146,10466,3029,145,11069,7610,10988,8512,11071,8109,7840,7299,7879,6800,9363,10002,7878,8002,9354,6986,9321,11068,9900,6971,11067,10893,10064,1762,10520,10892,11460,9366,5210,9752,10474,10368,9249,1812,1536,10050,766,2632,5179,10548,10938,10823,10284,9085,10782,9925,11219,5148,5070,4861,2594,2706,6010,766,2033,5799,501,4234,4796,2632,8172,5179,10179,5986,3989,8048,8041,7261,9930,9929,9921,4798,7068,8071,8439,8368,9461,9931,10244,10227,9817,4178,9543,10476,10149,9961,7086,8837,8793,446,9661,9195,5995,9160,7258,1349,11028,1350,9542,10063,2594,11021,11219,766,1215,6842,1257,2706,2033,2632,9453,501,10375,4234,5148,3989,4796,5070,5799,10878,9648,9634) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC