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,4100,4513,6595,1872,6102,566,7138,2590,1812,5544,7833,4131,2658,4983,7156,6635,2261,7016,8031,4220,2393,617,7250,7250,7840,2761,7064,675,1487,3392,3803,5094,7069,8902,8900,8514,3957,4872,9036,4349,7998,7654,8175,4510,3715,9220,9214,7985,2393,9278,9279,9049,6154,9258,9258,7563,7563,9406,9377,9444,9444,9527,9363,5545,7655,7655,7655,6774,6774,9614,6686,9730,9258,9800,9656,4800,4405,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,4144,8829,6314,6686,2657,8548,4209,5362,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,9430,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,2992,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,10823,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11722,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,7503,1210,1116,964,5777,4652,4209,8195,7445,1089,1089,8205,3162,7981,7981,7981,435,5143,7020,7020,7020,6687,6188,5995,6315,1586,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,6,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,2737,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,4901,4544,7823,1257,2677,4519,8901,4254,5743,4598,1311,4854,240,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,3287,8805,7829,8961,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,9542,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,9741,10512,9299,11187,11834,10847,5784,1265,4128,2021,1650,926,1917,1461,3595,986,6190,6609,1462,1084,4767,1681,1461,4209,754,6705,5371,6809,4566,6845,6103,4046,4049,6245,1016,6561,6249,6980,6104,5717,4050,419,6248,6252,1815,2245,6804,6766,6589,6793,4086,1526,768,6686,6588,2706,6679,2417,6635,6856,6639,6684,7138,1270,5148,6726,7156,2342,6674,916,6314,6595,2169,6792,5371,4023,6858,7158,3080,5339,2294,1895,1119,7050,7160,2923,2703,2123,5573,608,4061,2006,752,1349,1127,1253,8543,2933,8683,6713,4460,7138,1432,5373,7354,5812,4048,5266,3080,8687,8978,8925,8548,8910,5545,4652,4566,4258,8905,8795,5817,6684,9086,9030,6635,9000,9050,5339,5020,7126,4460,1349,1347,3701,8904,2933,9196,8688,9079,5157,6117,1299,4553,6696,9353,8632,9363,1298,6632,9258,8102,9406,6698,3195,9200,608,5726,5349,3542,8978,6337,9347,2118,3159) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC