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,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,9528,3913,1245,2778,6804,3926,1770,1771,1085,1771,1070,1769,1767,5148,1561,6964,6110,1768,4426,6966,6961,4164,6471,4165,6504,511,510,2469,3216,1370,6383,6415,470,467,2605,3702,858,4788,1741,3771,2035,5821,344,1165,663,979,3989,1770,1765,2706,3830,3370,4943,6371,4423,6354,1600,744,1381,455,3761,2331,1232,2183,3610,3172,1474,3172,2615,3131,1185,1738,3217,7752,567,7748,663,7964,4218,5576,7779,2869,8000,1351,834,3541,2334,344,6660,3250,5091,4701,2671,7604,2653,3136,3417,6413,4972,645,7033,7896,6940,3645,1098,1593,1407,4964,1561,1460,3797,4008,4830,5218,8095,1070,5091,1738,8150,1126,1145,2331,4432,5996,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,8389,10102,10110,1593,6740,10098,10107,8305,6212,10269,7869,2164,4788,9675,1425,5218,2776,9676,10054,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,8000,1098,4830,4348,1318,1593,3645,3797,5218,5170,89,4008,4164,1561,28,9655,4348,1474,744,9418,11409,10278,11402,1092,11228,4165,470,11252,1092,1198,4940,9378,4943,11546,8995,9838,11610,2824,2785,2778,6443,5306,2904,6962,661,5306,2904,7751,11663,11657,1237,11546,566,4165,3645,2760,1600,467,11485,956,57,9533,10278,11228,11812,3370,3136,1593,1474,8000,9407,10254,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,9528,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,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,5402,6832,6691,8968,2328,5371,1521,6645,5582,3346,850,4362,6831,1371,5996,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,10001,3081,10313,6130,10312,6889,1453,8828,10956,10517,10240,9959,7783,6633,3414,4834,4399,10818,10131,5947,9354,2467,3878,9545,104,156,7613,8219,11102,7920,2447,9828,10850,1308,11365,10269,10649,11290,3908,10666,4424,11136,11454,9838,10955,661,1145,11588,11523,10934,11603,1460,1318,8539,6831) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC