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,5735,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,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,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,4735,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,1444,2573,6772,3850,6660,5995,5623,2151,1681,405,4234,6645,732,319,1110,1371,5764,3731,5247,1572,802,3368,4538,6861,5692,1536,6639,739,2419,3550,4796,219,6075,3396,3037,4217,5460,2698,5743,3159,3437,2381,922,6862,3754,322,4445,606,2590,5179,3698,1915,447,1313,1298,1688,3625,4199,1038,3447,1647,2723,2298,2446,4861,1461,2863,2387,2944,3482,1576,2183,1159,1416,3396,3264,7709,5631,7036,2876,2419,1830,2518,2653,3217,3558,943,955,7228,6124,3788,739,4801,2299,1575,6858,1522,7126,4722,2639,3989,3304,36,7003,5175,4021,5807,8306,4460,7221,5215,4194,7883,7647,2989,1521,1954,2164,1559,4050,4082,3625,2160,2976,4218,5247,2932,2706,7835,7837,3142,3244,1163,405,8030,1718,1738,8182,8146,3479,4983,7654,5763,8150,8103,7761,1038,5732,1569,4452,7158,504,8222,8378,8371,396,1350,1521,4082,6069,1906,975,1826,8089,8281,2381,2329,1907,8290,4834,4131,3003,8142,739,3288,2985,4710,6880,8547,6255,6855,2164,971,8721,8628,8629,4005,1920,1954,8492,1830,3744,768,322,4217,1134,2863,4325,2054,741,8763,5373,7594,252,2989,8890,8851,3625,4109,3715,2337,8901,5839,8089,8904,8936,8925,3195,6707,8134,8932,2294,8933,1052,9009,9086,8871,5997,7981,4624,2946,9196,4767,1190,3026,2054,4240,9197,9249,8978,8795,8805,9220,8087,7121,8045,971,9135,9373,9366,9335,4136,8919,7138,5460,9466,9478,9477,9322,9455,8914,9539,9557,9578,9471,9464,4800,9353,9547,9607,9200,9332,9543,9654,7213,9333,9637,9680,9799,9798,9764,9769,3849,7640,9910,9904,9913,9914,162,9766,8064,7083,7840,7878,7879,7104,7715,7099,7082,6110,7096,7278,7249,7107,8065,7110,8049,7094,5770,8070,7960,2635,6544,8452,8384,8381,8393,7931,7895,8406,6131,7105,7654,7247,8407,7112,8349,7124,8041,7266,7106,7261,7717,8084,7246,7100,8461,8464,6968,8409,8407,7670,8408,8644,8641,8394,7277,8396,7153,8083,7266,8203,7251,7112,9053,7286,7666,8406,7258,8430,8404,8782,8473,8072,1343,2658,8683,9247,7082,8470,8644,8047,7085,9259,8034,8460,9225,8398,8462,7252,7095,9205,8832,8431,7943,7115,8475,7084,8395,8082,9573,9578,9579,7253,7272,8033,8473,8370,7589,8635,9204,7147,7655,7123,8066,7093,7076,7254,7280,5947,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC