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,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,1371,6639,2843,1656,6713,1521,943,4146,3181,6827,6827,7840,7840,6663,2571,2571,3874,8994,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,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,4710,5331,8804,4805,2706,8736,585,2932,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,11915,11918,11914,9639,8472,10513,11927,11913,11892,9354,9629,9630,11888,11881,11926,11957,12007,12004,10904,11797,10891,11334,10615,10614,8230,7869,3989,3830,5576,2473,8551,4136,7582,2337,7016,1920,3625,5005,5286,1257,6713,7759,4741,5081,1521,6866,7875,4258,4739,6707,1895,4131,2703,3936,784,7839,3129,3542,5614,4082,6986,2294,4209,4596,748,3080,4566,1134,1439,3413,4656,3117,5817,1347,5732,3134,7005,2944,3913,4460,3115,3976,6117,6793,1738,6595,608,4100,6639,5339,1253,5545,1215,6684,7126,3341,6858,5812,1347,6314,2933,7138,7156,4652,6713,608,6635,7559,6858,222,1349,7581,222,6857,7550,836,6679,2023,3454,797,4088,6792,7839,6674,8220,6703,7354,2875,4773,5025,5541,3368,8031,6686,8548,6337,6942,8548,3080,6986,7875,4513,8134,4194,7615,5379,2944,3263,1127,3162,4432,3195,2419,5629,6732,3201,3701,4740,4613,8543,1432,5477,8224,2387,8615,5175,8006,1532,1298,4539,8146,8587,1089,4875,4023,1698,609,2446,8535,8105,2594,3003,7896,6861,7709,5807,6124,6809,4411,5215,7362,5536,3558,8089,3244,3391,5020,6704,6595,2018,3559,8175,507,1439,36,6845,3139,3288,6821,6880,4538,6610,4258,8999,8900,8837,922,8101,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,2932,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,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,6188,5995,6315,1586,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,4544,7823,1257,2677,4519,8901,4234,4131,501,3989,2706,7878,7879,8933,8087,5070,7088,8450,7086,7112,4796,6354,3073,8305,3549,8955,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,1398,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,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,6780,5148,6891,7982,8151,5252,6635,1029,1349,4652,8358,8285,8151,6163,1559,7919,6684,7281,4598,3913,5516,5732,6557,4411,5322,6255,5331,320,5988,4046,4199,4452,3201,520,4574,585,4432,3933,3440,4987,5020,6863,4233,2025,4805,6553,840,1490,6554,5647,6552,4337,5693,6880,6243,5573,2703,2397,4918,2324,6556,4209,7350,8435,2546,8463,6968,368,7985,7986,535,8832,8782,4037,6869,4798,7592,8917,8034,8240,8948,2913,7599,7521,7485,2261,3201,3888,3895,3892,3885,3891,3889,8272,3883,5609,6493,9300,8877,8274,7294,8839,9072,1173,6174,6905,9437,1487,9438,6650,4121,8257,9439,9373,9459,6100,5,4708,3990,450,539,7501,7491,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC