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,397,863,271,233,6191,967,784,3036,6234,3997,5508,6427,6474,6426,6381,6388,233,6375,5371,4900,4597,4405,1462,4769,698,4395,1371,5322,4900,5380,906,5647,1453,358,6856,6366,6831,714,6642,6644,4788,6780,6766,6832,3549,5334,6102,1766,3896,3913,6616,1462,6638,6548,5371,5454,6691,3598,524,1992,5965,661,3337,7546,7665,2729,714,766,7213,1664,1183,1271,6141,3979,3581,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,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,8955,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,7114,7389,7241,7111,7147,5887,7068,7095,7110,7258,5996,7123,7100,7082,7116,7112,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,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,2932,1200,5148,766,2932,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,222,2387,3625,1257,6104,223,5995,7083,7078,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6609,6609,6616,6603,6603,6603,7655,8251,7089,10406,9793,7715,8791,8646,8412,9441,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,2590,6565,396,36,1532,1127,6882,2419,6569,975,6669,6736,6566,455,6563,6675,3368,5576,2869,1351,6883,601,6676,6993,6994,7001,739,6675,6779,6998,6996,6999,6842,6947,6795,6562,6544,6564,7003,6990,7063,6574,186,6676,6678,6571,6997,7059,6986,1521,7228,1856,650,7229,6992,7232,3029,7231,7225,7227,455,1057,7003,7234,1532,1131,7230,2187,7057,7224,6669,7223,3850,7233,7226,7237,7231,734,1181,1890,2192,810,6359,726,7299,2398,6512,6538,7230,6940,6790,6797,6537,7681,6536,4796,7692,7699,7233,7229,567,6573,7681,7684,7685,6735,7013,7184,7234,7687,7634,4109,6542,2889,361,567,6540,7691,8094,6539,7635,4834,8142,7047,6212,1266,8244,7079,6804,7124,850,7647,7083,1266,6359,6740,6368,7238,5995,7840,5996,8220,6693,1988,3574,6648,6383,6176,3967,6984,6947,7032,7033,1153,1983,4923,1380,1296,6316,5719,2889,587,2399,6583,7641,6726,7158,5769,8230,8109,1070,6366,3302,1988,5719,5719,3449,6428,6428,3522,8352,8352,7976,7976,7918,1526,6702,4694,9030,6122,7874,834,5961,2503,6428,2503,2503,6428,970,4639,8358,9258,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6003,6104,6691,698,5454,5582,7004,2986,7304,5371,3428,6740,7238,8220,6190,1095,5134,5134,5995,5995,2029,2029,6891,7592,609,9049,6549,4395,7262,1886,8389,324,7209,4659,1327,1084,8434,7971,8541,8408,6658,7975,7928,8290,1887,8435,8706,8737,8742,8363,7143,2775,7961,5244,6850,3440,7747,8922,8628,8141,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,9737,7953,6444,6034,6030,6540,6039,6023,6031,6038,8616,8825,8818,8818,842,8917,7219,9037,9187,8268,8628,1145,6809,4046,3830,7285,6115,7388,7561,7561,7561,7561,7427,6715,2594,8108,3581,7499,3337,5251,1126,5331,5402,6832,6691,8968,2328,5371,1521,6645,5582,3346,850,6831,1371,5996,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,10001,3081,10313,6130,10312,6889,1453,8828,10956,10517,10240,9959,7783,6633,3414,4834,4399,10818,10131,5947,9354,2467,3878,9545,104,156,7613,8219,11102,7920,2447,9828,10850,1308,11365,10269,10649,11290,3908,10666,4984,4424,11136,11454,9838,10955,661,1145,11588,11523,10934,11603,1460,1318,8539,6831,11621,11595,9949,11599,11953,9864,6249,1954,9300,3860,6255,4234,8142,5995,3860,4406,9321,4406,9321,2635,7953,2706,6259,1894,8222,7641,4325,3029,6618,3744,5484,1609,322,8434,8628,6256,5669,7635,5693,4349,5854,2033,6252,4109,5799,1954,6248,1954,6248,8706,958,7903,9542,4701,8933,8816,2473,6809,5995,9060,9075,6159,8230,9167,6350,6312,6954,8479,3523,4860,9389,4801,9879,9386,4639,8306,10346,10698,1973,10716,1993,10681,9004,8231,8941,8941,10065,10065,2342,2005,7238,10056,4544,2324,8498,11069,6733,6800,8002,8860,7416,7503,7369,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,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,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,7804,4226,10211,10172,7806,3336,721,576,7219,10707,6613,8222,7579,7837,4079,1210,7834,4639,7835,7836,6740,7143,4087,8358,7238,223,8220,8517,3282,7989,8306,8547,8480,2117,8610,435,8610,3014,8629,8214,5143,4218,7923,3850,8842,1207,8905,8912,6599,1127,8916,9000,665,1345,8578,8780,9046,9130,9195,9017,1461,9072,3062,4625,8933,8706,5154,9200,9242,984,9254,7907,5536,9300,3761,8495,9322,9332,9333,9334,5732,9308,9289,9291,8103,9337,1057,179,8150,3595,2135,9456,3059,9419,9290,8688,7803,9196,9347,9541,8543,8306,9552,8306,9353,8306,7581,8306,6117,9607,9603,9604,7143,6857,1890,9641,9634,9654,9643,9668,9642,9644,2360,9377,4240,9680,107,9616,9761,9234,8805,9648,4219,9676,9769,9766,9780,9800,7856,772,9798,3844,4800,3303,2299,9116,2294,5515,5765,3590,2398,9258,1416,9913,9916,9938,9942,8913,9635,5841,780,9961,3844,9543,9945,129,9471,3159,3788,444,5692,1834,8870,8844,972,10047,6848,1727,1822,360,10056,734,7615,10104,6681,5812,7016,2674,6827,1181,10128,10129,9086,3181,10141,10149,3437,10119,10120,8925,10048,10061,967,9472,1522,9963,1906,10093,220,4126,9116,5821,2743,1485,1000,152,10229,10242,10241,180,148,958,1461,2135,2192,3585,2299,10131,10282,10284,8884,4947,7019,10273,2687,2642,1826,3561,10283,9936,2421,4656,4566,4972,2571,10342,10338,10246,9348,115,10300,10380,10373,10209,10358,9050,4527,10374,10373,10440,5743,6171,10469,4168,10467,10476,10416,10479,9374,9638,10042,6267,9220,3608,5877,3035,4986,8851,9454,8837,10523,10114,10244,10527,10247,5551,8902,10394,8800,10549,10541,10537,10548,10543,322,10514,8514,1954,10021,4385,9193,1057,7550,6691,162,8901,10671,10649,9904,4767,4696,10665,7017,7582,10674,10569,5729,10745,1954,10747,10787,10798,4023,10780,10814,10737,10663,3715,10784,10836,10688,4082,10135,10782,6713,252,10878,10699,10870,5373,10935,10894,7016,10910,10892,10934,1350,4136,1521,10938,10918,10966,5142,10895,10893,10656,7140,10397,606,10782,8900,10988,5379,6828,2192,10233,7614,1532,9834,6643,10708,11028,10709,7064,10710,9081,10285,3054,7021,2270,2271,1131,10221,2672,10344,3825,10345,10513,11084,10320,123,11090,10661,10662,11105,10398,11104,7143,10990,11094,6838,239,10899,10778,9872,10673,11104,2642,7016,7710,9254,3391,9768,9254,9270,1277,7016,955,6861,1441,2654,1055,2707,1160,1159,30,243,11121,10376,10917,1160,30,11123,11127,11128,5631,11132,8687,11126,10765,11089,10454,5875,743,7758,10094,11135,11142,11136,10964,6849,2912,4982,10857,2698,10971,10733,9453,6852,10343,7864,780,3964,8835,3657,2639,3542,5379,4219,7855,1277,1042,8919,11166,3775,10148,10375,3778,5678,4665,9928,10130,5305,11180,10719,1835,11195,10473,6696,3787,6853,9105,1176,2671,1313,6661,4616,2919,11219,11222,11217,10734,11230,11201,3100,10819,11237,10657,2709,10434,4233,1119,11220,8535,11199,9234,11200,4209,5487,9096,3457,2446,10861,8031,5545,6731,11198,11235,10528,6731,11084,9722,11288,11287,11268,1209,11304,11302,11272,4056,6862,6779,11324,11325,8134,9343,5046,36,1698,2590,748,5903,11349,3936,11041,11353,3376,3195,3139,4028,4648,8802,11361,2592,2919,2685,11359,11360,2873,4536,11389,11351,11374,3482,2655,7036,3396,9402,6866,11409,10940,11417,11266,11424,11423,10715,5013,11314,11266,9811,10062,10146,24,4875,10714,11142,5252,11443,8010,10530,10714,11442,6730,9922,11438,1049,11433,1050,9221,739,11473,11437,10288,10234,11480,11456,11450,11388,11491,11494,4329,11455,9615,11488,6692,11381,11498,11489,11347,11344,11468,768,1576,11476,11371,11477,11382,9750,4648,11102,4882,11416,2555,986,9809,9807,9808,141,986,11290,3368,11492,152,10842,2477,7709,8224,3523,11599,11042,10912,11595,11598,11613,3041,2456,122,3500,3540,5328,11621,1299,6693,11373,11597,11593,11619,11518,11600,11606,11655,11620,11648,11436,10368,11661,11647,11670,11435,11451,4233,11479,11646,11678,11594,11303,11446,61,11523,4432,11663,11691,11644,10002,11362,1113,11690,10685,11698,11703,779,9965,11719,11672,11669,11724,11680,11714,11126,11446,11702,11705,11738,11737,11725,6986,3401,925,8707,8520,9222,4061,11385,2491,7760,8104,9317,5047,11658,4099,11170,9068,8483,9070,6337,4849,11764,11765,11673,9532,9987,7896,8146,2454,11379,2419,1298,9531,258,11657,5553,6902,258,11770,11772,3714,218,11752,10635,9018,11786,11660,11807,11812,9511,7362,11816,6901,11787,11785,11282,9036,10967,5629,11330,11659,9986,11681,11716,9228,11285,11827,11819,10764,4696,11821,11820,11842,11845,11829,11010,11846,11826,11869,11831,11872,11662,10956,11851,9917,11822,11699,11847,9964,9967,10877,8284,11832,11871,5885,11870,11849,11873,11900,10743,2921,9211,9166,9642,9643,9644,11921,11828,9641,9333,7719,9332,10744,9571,11480,9397,11610,9569,10359,11850,9832,6069,4417,946,11965,11978,11977,11963,11972,6553,6552,11966,11982,6315,11964,9387,10267,3731,12010,8182,10865,11990,9460,11860,10354,9897,8732,7048,4178,10818,11028,6367,10649,10892,1777,6793,9386,11253,10212,9320,10505,9865,11219,11195,10248,9871,6240,11169,11217,10687,11379,9420,10831,5269,10002,10893,4716,10282,11349,11358,11384,3327,11101,9394,9394,2331,1245,4964,6221,4178,8324,6740,7238,6270,1557,1380,8220,8247,5763,7300,217,6508,8345,8490,6512,6510,6103,6199,6533,2467,6373,6768,8244,2989,7923,1303,6831,2374,735,9001,8151,6880,9243,6855,7594,510,9505,8869,9921,1052,9450,5839,9900,10228,4405,452,4800,10305,8135,2164,1557,2164,9931,11134,8435,8257,10086,8922,11352,9871,8262,11437,5997,1049,10741,11101,8377,11519,4720,6806,11670,1803,1831,3824,1016) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC