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,6189,5915,2849,4682,2849,4682,6365,6001,1000,6102,2546,6239,3197,5564,6832,6737,3250,5717,6368,6361,1520,3598,5380,254,5915,6138,5322,409,5763,2092,6638,6361,6190,2897,1084,179,1740,3492,3395,2171,452,3863,6947,587,217,4566,6803,2749,7044,7009,3595,6957,7208,186,6890,1645,1511,6561,7215,6624,176,5070,6812,5956,7159,5081,7579,2092,358,6175,217,1453,5924,7072,7124,7258,7292,2179,3389,7084,5947,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6962,6586,6588,7019,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,9741,10307,3904,8739,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,11812,1807,11994,4580,11994,10454,6595,5331,3904,6599,6141,4598,6190,3598,2830,5564,1500,1645,1565,7374,6190,9159,8022,9460,5454,3863,5742,3334,1973,5717,5733,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,9866,3863,7286,6751,6742,6742,3890,8228,6010,7869,8109,6844,501,1461,2658,6726,223,8358,6733,6190,3337,8485,6740,7238,8220,8514,4061,6690,8659,4401,322,1591,1070,4983,3850,7546,2933,7904,6768,1917,2546,8512,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,7113,3882,3897,3885,659,374,310,389,546,540,3893,553,964,1242,524,6611,6611,1151,545,1167,6209,4076,8289,7572,1810,7124,6405,6408,6408,821,7083,8198,820,8199,892,892,8438,8363,7646,7646,7122,7124,7107,1500,7094,801,1265,915,9274,5936,8171,7666,7666,7666,2458,9762,1167,9949,7785,10386,8168,11227,6368,7026,6854,9684,2349,1167,376,8881,1783,9438,367,11639,11640,3885,7165,3897,3891,3889,3888,11209,3884,3895,11207,9437,3893,11205,6745,8981,3892,11203,11206,11204,9517,3896,367,11425,11355,11430,3896,3887,6743,8980,11463,11427,6076,947,466,11077,9144,6103,11385,7610,11052,7311,11365,11251,11421,11130,11419,11422,7892,11013,7697,3997,10981,7696,5635,1927,9555,10906,11187,11463,3997,11116,11269,6653,11063,11376,788,4386,7172,11402,3442,7186,7286,10272,8228,7715,10980,10850,8364,7176,11370,11431,8280,11515,9082,9473,4558,11539,11497,9500,10433,11556,7890,5763,7269,9959,11496,6873,8965,10655,176,10655,176,10655,10805,7178,10480,11365,11795,1016,11780,2791,7179,11150,11768,10526,11746,7374,9472,3417,10416,6633,3647,10242,6795,2454,2956,3418,10627,341,10650,10651,190,10241,9959,8534,5596,228,3474,8629,10532,10611,10649,2671,10697,9202,9273,9403,8926,10872,10909,10951,10758,10839,10879,11126,1727,8870,1647,11121,11028,11072,10786,11140,2334,2454,4722,5765,10651,10718,10242,10798,11226,11214,11239,11018,11303,11104,9551,9569,9570,931,10915,6361,10951,10128,11325,11351,11237,10739,4219,11095,9417,10836,4136,11409,11349,11363,2151,123,11678,11202,11690,11377,943,11736,11661,10730,11752,11724,11523,10698,9887,5566,11854,11904,10494,8541,7903,9762,653,10604,4805,8292,7042,11085,778,10336,3511,11216,11568,10107) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC