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,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,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,466,1425,741,4346,2995,4164,3136,4911,6544,2976,1766,5576,2869,1351,6940,834,6154,7228,7059,6809,7641,3830,6595,6154,2992,754,585,3080,6312,4131,1433,6845,5817,5339,6104,4258,6117,1953,3542,466,2658,4199,5912,2294,608,6862,4460,5371,6870,739,1347,7126,228,3492,1699,2748,5339,5142,2337,3625,36,1461,3542,1253,4535,4092,6124,5545,2989,3368,255,5981,5995,6362,1126,1198,435,1234,2995,4778,2451,6391,1711,3581,7107,7077,8081,7298,7298,7245,7245,7105,7297,7297,7297,4178,1970,8446,466,4788,1303,3511,1215,156,1250,1498,6130,4767,5400,2029,2736,4558,1425,450,5995,3026,4791,1210,752,5729,1762,2743,5431,6490,6561,435,5922,1461,4128,3936,916,5936,964,1497,3558,5251,5629,2054,5924,6986,6710,1433,1537,1917,7100,6632,104,254,1089,1215,4796,2337,501,7113,4861,7102,4762,1349,4216,5322,7280,4199,714,4220,7054,6707,4519,4401,1371,7304,5371,7097,1145,2023,6264,7072,6104,5535,934,6365,609,4983,7938,4233,52,5430,6561,8306,3244,223,2677,4639,7238,6740,8590,8183,1439,7875,8615,7023,5373,7546,2986,5143,3014,3581,5484,1126,1645,3018,3941,4510,8783,322,2944,766,6192,6113,6010,4985,1516,6001,2168,6559,4682,6118,5893,6158,2269,6154,508,6011,566,219,5222,5321,1425,5917,6782,6362,1603,3824,3856,4417,4617,5011,5208,6785,2911,3216,6780,423,5837,6136,6806,6691,6973,6972,6947,255,1370,6156,6157,5222,239,6059,7299,7034,7023,7303,6795,7206,6633,6981,4788,1029,6337,947,1126,5334,1325,4432,466,3549,156,566,5582,3760,311,1738,464,7904,6192,6813,4218,435,7833,1245,4385,1207,2776,3761,7928,6163,5542,1532,1600,698,236,3131,8557,5011,8614,8535,8554,8550,8614,8305,1029,8547,2331,4983,7861,6712,7602,2737,7599,5143,8871,7928,6778,156,3875,3046,3531,4730,4765,5893,6813,5915,308,6156,9448,7982,8151,6644,6831,6767,7938,9403,9307,6829,801,7913,6953,6894,665,9889,9926,9933,93,6163,8284,9665,10067,9953,9721,10046,9722,9449,9545,9603,10118,9754,10055,10145,9723,9835,9836,10112,9942,7812,10679,10113,10501,10512,10495,10628,10626,10697,9724,10237,10353,10358,10366,10482,10608,10497,10610,10876,10715,944,11330,7889,1886,11291,10294,11287,1210,10877,11101,10938,11136,10935,11134,11200,6898,11232,11347,11290,4899,9558,11233,10684,10733,4603,4602,4600,4599,11358,9728,11364,7019,8222,9993,11219,11324,3595,9195,9552,9925,11027,11112,11115,11127,11435,11552,11738,11449,11447,11456,11586,11236,11460,11551,11372,11622,11825,11371,11360,11699,11773,11524,11135,11774,11832,2867,11845,11441,11363,10910,10493,10904,10820,11119,11585,11587,11589,11592,9342,6836,11935,11936,11937,11938,11849,6010,1453,6875,931,6986,2342,1303,5576,529,6042,1165,6513,2300,1685,1411,6359,5386,1368,7636,358,6177,1402,1740,2006,217,2520,2573,6971,1248,6726,1453,6155,501,7097,4860,7119,4218,6176,6658,7123,6135,6190,4769,2029,3772,6104,6642,3725,2389,7158,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,11686,11890,10702,11211,11772,7127,10664,8764,1766,10291,10292,1766,2727,6656,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,5756,3189,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,1645,8628,8306,8783,8933,8361,3287,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7155,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,3549,5334,11213,9039,6785,10579,11439,9897,7849,3169,5770,7505,7505,7301,7301,4639,6239,7374,7374,820,820,6613,5996,8306,8828,8828,8828,8828,8828,8828,8828,8828,7130,5421,8973,8973,8973,8973,8973,9471,1771,1770,10041,1771,1767,1767,1767,1767,1767,8864,4199,6809,9391,10892,10543,5376,8515,7079,7111,7294,7124,2706,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,4801,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,9133,7190,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,10486,10487,11045,11022,4349,3714,5995,3913,1084,5322,576,6364,4701,2989,1379,5380,6528,4535,5609,4842,1724,3860,6855,2951,2071,228,566,1461,421,4600,7304,1248,7130,3428,1370,3549,4395,6588,7829,7751,947,3549,5334,1371,4796,5148,6644,1439,6780,766,2706,1145,5421,4131,4860,1461,6986,2261,947,435,6691,2023,2023,2023,4452,4765,4765,8684,4349,4349,1766,6509,6511,6514,6515,6538,6537,6536,6535,6505,6533,6532,7843,7592,6354,3070,3073,3071,6689,6688,8324,8323,9590,8325,9588,9589,9430,9601,9555,4784,28,1126,4788,5251,5251,1425,1533,2995,1210,3803,3392,466,1741,3872,2736,5732,5732,3080,5339,7883,7883,2294,4258,5545,2933,3803,6809,548,1741,6845,6223,546,6042,6496,5763,540,3094,7616,1917,7751,2729,3878,5228,5246,5328,4103,6397,3872,2451,6218,543,1764,7987,7903,7972,7973,2677,1145,8117,8140,7833,1126,5143,2776,28,923,1234,3189,4872,5089,5094,1520,8222,7861,5112,1207,956,3392,6901,2915,6902,7047,6902,3048,537,539,8306,7986,6124,4144,7208,4785,5459,5430,28,947,7776,906,466,1370,1741,7029,7047,7047,1318,645,423,1092,8252,532,1600,8888,4855,4855,9017,545,7047,8542,5914,6034,7829,7029,7029,9021,7592,3878,7681,7681,6552,9554,9547,9547,9007,9007,9614,9777,9254,7710,9675,9880,6222,6499,6214,6220,6218,6215,6501,6216,6498,6497,6223,6212,9965,9254,10265,532,9648,10258,10212,10212,57,28,9487,10610,10610,11089,10622,11089,10622,7084,7100,7102,7068,7072,7116,7077,7069,7123,6714,6714,6663,6133,6310,1085,7096,7272,7106,7106,7269,7241,7114,7250,7076,7280,7275,7125,7122,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,1371,6743,6523,6141,6141,6396,4519,1746,5602,5602,2677,924,924,6149,6377,3895,6622,6622,4788,7670,7670,5995,1764,1764,4079,7593,7593,6151,1730,8220,8220,7072,8067,6809,7082,7082,8233,1198,3803,7068,1992,5998,4770,8326,8244,3850,8245,8268,8329,8247,3392,1234,8246,1049,6659,7093,4519,4519,7878,7878,7656,7656,9425,6521,9381,9381,7108,8002,8002,7761,7761,8793,8793,9548,9548,6146,6800,5997,3872,9189,9554,6526,9376,9376,9558,9558,9537,979,7019,1371,7083,6880,7298,5251,5251,1207,28,7856,7834,4985,2995,3048,3392,3392,4029,5251,958,1461,6315,176,7899,947,2447,1533,956,8251,5732,8063,2677,1198,1126,5877,3872,2776,4432,5143,3189,3564,4645,6659,4690,1145,4788,1917,566,7970,8000,179,8793,4701,361,3131,5094,1741,9195,3014,2451,310,3803,4791,4791,4872,5513,1237,9243,8927,2331,9489,9780,167,5431,4617,9325,466,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,2932,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,2594,11402,11497,10257,11324,11315,11281,11497,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,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,8955,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,7354,4566,6683,10770,5596,9377,8808,10674,5431,1234,173,4432,10226,10079,8927,9900,6397,10272,11262,11187,10146,5513,145,11335,11381,9922,6278,1775,3368,9338,11287,5247,7250,11108,5236,28,9464,7876,10397,11225,7662,7661,4023,6679,10893,1145,9888,8568,8424,8740,9977,5175,4023,4061,4969,3989,6595,228,4233,9968,11630,7143,11652,11633,7671,9560,8812,9251,10168,8813,11517,10748,10472,10675,11684,9417,10904,9036,8517,11703,11658,11442,9874,9873,9876,9875,1173,713,2995,923,11388,172,8474,1970,10577,8929,7655,8081,9205,10854,9461,10855,9503,8889,11609,11385,6635,9980,9896,10869,11398,9246,8140,3558,10078,11753,8139,6548,11795,11473,11689,11794,10624,9220,10860,9638,252,10042,11822,9904,11838,11130,9401,7670,11646,10802,4788,30,9453,10230,7036,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC