thisMySQL 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,3415,5623,1727,1647,3850,3500,2380,1313,319,808,772,986,6564,3136,2151,463,6562,3585,1727,1237,4021,1098,1277,3610,5552,732,955,6644,6677,6599,1856,3454,447,780,1915,1160,5170,645,1460,2760,2707,2912,2270,2271,219,6779,1441,6709,2469,3351,1159,3482,3417,243,341,360,2685,652,2653,2654,2671,2454,3304,3447,1834,2602,3341,6827,2639,3844,943,2518,2298,5657,1871,3657,1869,231,2592,2477,2919,3843,5509,2974,2299,1822,1829,1297,3714,2334,4217,3787,3778,3760,2456,231,2477,4796,4806,4808,3159,6828,5331,3035,6192,396,5692,2873,3437,975,6992,3447,4798,3825,699,944,2446,2387,1416,4855,1893,2864,4722,3788,2934,1228,922,2723,7003,836,4008,6852,1561,6901,6998,5247,925,5743,6663,675,1038,255,1521,5078,5142,2698,5631,6902,1131,6117,5764,2337,455,2160,3625,6188,462,7016,7224,7221,7234,7047,7237,7230,1110,447,1277,6852,2654,6643,5552,2576,1313,2685,463,3825,231,4982,3217,2876,3447,2518,1277,7003,802,2698,6999,1915,5371,4219,6990,7051,2469,5631,2592,6562,2685,7222,7221,1822,943,6397,341,3778,1829,3181,6993,3843,4126,396,6122,2590,7304,3195,6172,1568,308,1127,6590,1453,6104,1647,2299,6950,1432,7858,3447,7784,7865,7803,6998,7864,6853,836,6793,6001,6942,1313,2390,7991,1200,5339,6677,6350,231,1228,3610,6856,3657,5305,1038,6669,5647,6998,2932,5995,4796,5148,5995,1351,975,2869,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,3169,435,3134,1718,734,228,1207,3645,6986,1600,1593,744,2331,645,6731,1000,223,1318,4855,4199,2571,1460,6643,2671,7029,7020,7047,4164,6902,4165,341,6998,1577,2469,2685,6827,3584,4219,5770,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,5996,6122,3879,4714,7855,6998,943,6031,2571,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,2571,4219,3989,2723,5148,2671,3843,3304,319,470,3417,1829,3584,7779,4722,5552,4021,986,3351,3778,6643,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,2380,925,956,6990,1600,360,470,1575,744,2974,2151,650,652,243,1487,3645,1237,6885,7029,6563,4008,7063,8289,6564,925,1098,1869,943,8148,7053,7047,6576,6570,6573,1727,5947,6569,6574,2331,947,6883,650,6998,6678,7122,7228,6562,5961,7105,7124,8942,6362,7050,7175,8182,186,4131,6575,6795,6669,7757,7237,7232,7227,9321,9982,9531,7057,6571,8726,9487,1856,10205) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC