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,6364,501,470,1098,6572,4510,744,6562,467,1474,4796,1568,2331,2033,423,645,5454,2457,6574,6571,6576,4126,4019,5089,5112,261,5623,1487,6644,6767,322,466,6766,511,360,215,1160,1441,5143,2912,3590,6539,6544,444,652,955,1561,1834,6040,6542,1371,1070,6660,2876,5719,6030,3302,1439,6794,6189,1738,5877,6971,7240,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,4834,4769,6578,6727,1707,4422,9112,8873,4437,863,9111,8872,9113,4860,8649,8872,9049,4920,3169,435,3134,1718,734,228,1207,3645,6986,1600,1593,744,2331,645,6731,1000,223,1318,4855,4199,5735,1460,6643,2671,7029,7020,7047,4164,6902,4165,341,6998,1577,2469,2685,6827,3584,4219,5770,5305,1038,6669,5647,6998,2932,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,2635,7160,6104,7794,3384,6845,6858,7594,4555,5719,1070,3522,7904,6898,7304,242,3380,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,5996,6122,3879,4714,7855,6998,5735,943,6031,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,10846,8260,9192,11019,566,57,3760,231,6942,1869,2446,3454,3787,1738,501,1461,1228,836,3657,6570,802,1055,1160,1568,943,772,743,1441,1277,1727,1915,7864,7858,6852,2592,6827,1110,6845,7856,7758,3590,7221,3844,5623,5765,2654,3303,7034,1577,1822,2685,463,7232,3181,6853,219,5509,8488,1416,2864,3844,3418,360,8094,944,1522,2653,243,341,2469,1575,2334,3482,2956,7803,3788,1313,4219,3989,2723,5148,2671,3843,3304,319,470,3417,1829,3584,7779,4722,5552,4021,986,3351,3778,6643,5735,7784,6849,5170,6570,8616,5070,2454,2706,1893,6573,2456,6562,652,8707,6574,6571,6567,6998,8684,7224,650,7031,7229,7232,7221,6675,7227,3540,6676,5088,6564,444,7063,6563,6568,6575,6565,6576,6883,6574,6735,7228,6678,6882,7013,7690,3415,1856,6996,7757,7687,6999,6997,7688,8726,6992,7689,8147,6990,7223,7231,6994,7681,8148,7001,7059,7235,7225,6736,7057,7692,8993,6885,7684,7685,6669,7052,7234,6902,7682,7683,7226,7699,7233,7691,8919,7237,9003,6007,1834,8994,2151,6676,9002,9068,6860,8997,8996,8814,1371,6639,2843,1656,6713,1521,943,4146,2737,3181,6827,6827,7840,7840,6663,3874,8994,7803,341,7784,3418,3447,6853,2653,2671,3417,1568,1647,4126,6171,3437,5692,5743,2334,361,6515,4316,4701,3159,8761,7928,8290,8304,8845,8818,4936,4944,7761,8706,3760,4765,1370,1126,4411,6310,231,243,946,2469,836,7859,1127,7864,7034,944,1228,1297,1416,6942,1522,7712,1577,7031,1869,1893,2446,2087,2451,2454,2456,2995,3014,3059,3189,3201,6659,3778,3843,3303,3803,4092,4029,8894,4219,1313,6838,4690,4785,4791,5756,1533,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,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,4362,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC