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,6562,6570,6735,6669,6902,6571,6901,6568,6567,6990,6993,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,863,864,6583,6752,6780,397,6493,388,6204,5956,1121,6986,2590,6565,396,36,1532,1127,6882,2419,6569,975,6669,6736,6566,455,6563,6675,3368,5576,2869,1351,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,7157,7231,734,1181,1890,2192,810,6359,726,7299,2398,6512,6538,4362,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,1769,1767,5576,6940,1098,6970,6967,3216,840,6966,1351,6394,1600,834,943,6965,2331,467,1092,6177,3921,3585,3100,3941,6599,1248,3479,4046,3172,1038,5148,5215,4740,1038,5764,455,4045,2421,4739,734,1152,5081,4088,4455,5837,2387,4539,6703,1163,2381,2632,5331,4861,4385,4045,1954,5543,4670,7810,7718,7857,971,6552,4752,3989,7761,3976,3493,6563,585,6556,4209,6863,6576,4878,6993,7840,2863,8183,7879,7878,7857,4773,176,4220,1917,7903,7834,2674,748,752,836,3454,967,1826,231,8793,3715,4082,1521,3370,7614,8888,8925,8901,5373,7615,4258,5339,5545,5817,7126,5247,3368,7920,2294,6861,1253,6858,7883,3080,2933,8615,8548,8999,5837,7857,608,7839,1347,9372,1699,9614,9195,6809,6845,6104,9200,9541,9366,9300,7619,9925,9321,7619,7875,9897,8890,9463,9937,9777,9349,4460,9888,7928,4223,9921,9478,10065,8846,10039,8948,107,9615,9993,9464,9661,9808,8819,3549,9258,10090,10087,9527,10243,10089,10088,10342,3346,9052,10260,10480,9374,9453,10548,10212,10265,10259,10127,9798,9929,10568,9347,10476,9634,9930,6117,7581,10784,3080,6857,8543,9648,10878,5339,10086,9961,10915,10523,10375,10626,6632,10149,10937,6793,145,10738,11020,4765,9045,7919,10210,10913,9387,11142,9389,11022,11235,10804,10938,11219,1232,11195,2615,9198,11280,11234,11220,11281,10227,11282,11122,11021,10528,11324,11272,9647,10110,10911,8889,11131,9959,10911,6824,4901,10014,10013,10012,11423,10108,10109,10016,11495,1232,10017,10018,6981,10004,10005,11489,10648,11455,11608,9212,10619,10164,10015,10621,10620,11443,10894,11314,11361,11645,11435,11349,11705,11551,11699,11670,11661,11491,9220,11646,11495,1185,11235,11280,11608,11703,11488,11455,11838,10355,11919,11923,11872,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,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,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,650,6998,6678,7122,7228,6562,5961,7105,7124,8942,6362,7050,7175,8182,5735,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