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,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,1439,6793,743,5088,7290,6901,2863,4217,7047,7837,7275,1895,2677,6902,5623,4432,1954,3590,6901,1826,6553,419,7063,2677,7029,341,6860,2956,3760,7879,7840,341,8502,6718,7674,8171,8436,470,8587,8488,8095,8616,8094,8587,8886,2956,3788,6562,6563,2334,5222,3417,3282,743,9002,8997,8993,8994,9003,9001,7233,6990,7783,7029,8617,1416,8870,5765,1577,2889,3029,2766,6824,5692,2331,7034,9002,8587,8993,2957,6790,8004,3590,9321,6780,1568,7712,6902,7029,8488,8095,8780,7619,3564,1131,444,2331,2334,2592,955,9390,2956,2446,9363,1834,971,3418,3479,8923,1893,9463,7787,2454,9511,9512,9531,9532,9551,9568,9571,9570,9566,9002,9001,8094,8095,7000,9531,9419,1532,9321,8996,8094,8834,2680,9783,1163,7618,6882,2698,9981,9982,10005,10004,10012,10013,10014,10017,10015,4422,7907,10019,6828,10109,10110,9947,9982,10108,9948,10118,10165,10112,7830,9570,9226,8845,8461,7674,6556,6557,7618,926,6095,2923,6551,6555,1278,1815,6068,5856,9987,10267,10221,7792,6205,9987,10413,10414,9620,9619,8083,8034,5066,3358,7605,10397,2329,9532,10345,6555,6551,6248,6552,7829,10266,10141,10127,10632,10635,10395,10266,10621,10620,10619,773,9200,9116,8978,9290,6635,9798,8431,9650,7272,9742,10571,10574,10585,10772,4788,3872,7682,173,9566,1198,89,341,89,341,190,185,190,185,2956,6853,2956,6853,3418,3447,5459,7784,7803,435,9512,9512,8252,9511,8252,9511,3891,3892,7986,3896,3890,3884,6493,3889,8271,4659,8144,1738,5995,5543,5373,5339,5349,5251,947,947,1349,228,6559,1038,4395,1461,8089,9526,9527,9811,1215,5995,1257,8306,9831,9569,9551,9566,2331,10020,6571,9982,10081,10093,10088,10087,10090,10080,10092,9991,9890,9222,10165,9921,9913,10128,7803,9981,9570,10002,8252,7029,6901,10288,6902,10413,90,7222,9270,10086,10094,10056,5170,3904,6354,3073,2698,3070,10134,9603,9475,2271,986,3351,3429,5631,10132,10133,2707,1159,4901,5837,10210,10018,780,743,772,4406,10277,5131,4653,10285,10286,802,1441,1160,1110,10205,3825,10287,7758,7858,6852,7865,9353,7864,1915,2654,1277,9607,732,10207,10241,10242,10104,7856,7855,7221,3731,10130,10209,10148,10344,10345,2912,10374,8946,10376,8919,10358,6902,141,10243,10373,6163,10065,9406,9511,3731,8910,8095,10416,10543,10400,9910,8813,10399,8812,9252,10401,10479,6901,9929,10120,9937,10362,10476,10530,9769,10046,10660,10661,10662,10112,9386,10633,9748,10119,10118,9761,4240,802,5321,2657,10709,10708,8687,10710,9253,9251,1835,1190,1177,9466,8387,1176,7554,7754,7755,7756,7927,8509,10528,10062,9770,9222,9253,9251,10787,10857,10523,10395,10836,10814,10870,10396,10358,10569,9614,10632,10244,10634,10917,10918,10568,10635,10584,10583,10636,7029,10919,2912,7674,141,3351,7856,9512,9531,9532,2658,9551,9566,9569,9570,4199,9568,11028,8615,4624,4730,8902,446,10212,10895,8888,8278,8276,8275,10657,10913,10911,9981,8799,9987,10141,7221,10205,10207,9277,3428,7239,10066,10165,10236,9402,8031,1253,5545,10413,4969,9454,11027,10414,7636,8095,608,1368,10549,10837,848,10512,7580,4766,9391,9982,4233,9571,8252,3100,10649,11112,6163,11141,8842,5013,5154,10113,10114,8629,8837,3029,228,10063,11142,9904,10967,11102,9543,217,10087,11219,11126,10938,11217,4337,6863,11202,11122,11220,11100,11084,11123,28,11106,11268,9638,7550,10397,11180,4984,645,1917,9950,11219,10784,661,10127,744,6731,57,467,1092,89,4785,4536,2873,11374,2871,6730,4329,6692,4882,6776,3100,2317,6185,11330,5131,4406,11228,4046,4048,4045,10377,8147,7057,7857,7003,6736,4049,4050,6741,2033,8517,6705,4136,7016,9251,8812,8813,9252,9464,11302,11235,2639) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC