this

MySQL 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,993,6786,6383,2171,1666,4671,4923,2417,5782,1726,6794,1296,2729,1153,1988,6962,4920,5853,1973,6844,317,1732,6003,1462,1380,4437,4437,2749,2749,6794,6189,1738,5877,6971,7240,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,2571,4834,4769,6727,1707,4422,9112,8873,4437,863,9111,8872,9113,4860,8649,8872,9049,4920,3913,3609,5927,7304,7278,6004,7215,3428,1988,7143,3604,8220,7840,7833,5995,7112,3609,8082,8358,2473,2473,2473,8514,8947,5402,5402,6962,6966,8352,6968,7805,8354,8354,6969,6969,8351,8357,6970,6970,6970,8356,8356,8352,8352,4716,4716,7576,5371,2635,8349,8349,8355,446,6642,6167,1947,6774,4986,6599,848,4395,6354,3070,4662,1095,2951,4512,4706,3428,1084,4218,6740,7252,6658,8389,8412,8412,2635,2635,2635,2635,2635,4683,7906,8283,5782,7079,7079,6154,6794,5996,3860,391,387,6151,6159,1126,6562,7238,6140,377,1558,2005,2635,7576,7576,6584,7084,7084,7272,7708,7708,6316,6316,6316,6586,6586,6817,7920,7833,6444,2294,1825,7888,6548,8793,6844,6984,8887,8196,5858,5863,6006,6631,3266,6810,6770,3515,3889,8111,3882,4769,4724,3895,6725,3888,5927,6971,1462,8436,7012,3884,6450,8390,368,8003,5922,3896,6797,3967,6004,6983,4297,4299,4302,9028,1265,8355,7205,3581,9049,7160,8661,8490,8917,8885,6490,6209,7912,9502,7576,6715,6715,6726,9044,2171,987,987,1604,6727,1462,6820,993,4918,226,520,7966,3863,1981,1296,1296,2041,1462,1981,5769,7849,1988,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,9737,7953,7892,26,6768,2555,7258,7115,1988,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,8365,7642,9451,9843,9796,9846,8266,9995,9972,9665,9129,3071,9842,9350,9855,8203,314,9806,8228,7105,7104,7107,7103,6689,9854,9867,7155,9794,9580,9498,7070,9632,10238,10053,6242,9880,9622,9205,10176,7120,9563,10254,8450,10256,10095,4121,9134,8732,9621,1768,10232,9259,1616,9204,10077,7632,9539,8047,3358,10037,9933,7121,6898,6272,7111,3889,7125,5769,9529,6613,6582,8048,6579,7256,5051,8965,7119,9084,9578,8201,7152,7117,7116,8739,8053,993,9975,10510,10571,7895,9563,7675,10239,10544,10590,10612,10640,512,7087,10587,10659,10690,510,8824,10592,8770,9054,8644,9134,9563,9055,10586,8053,9055,9134,7088,7096,7086,8055,7106,7083,8034,7297,11212,11189,7243,8240,9622,11187,9746,11188,11196,7298,8499,9206,10588,9563,9620,8407,10272,10692,8438,8404,8208,10614,11150,8928,8236,10615,10689,10587,8410,9813,10869,7122,11108,8782,9609,9608,7668,7669,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,1770,6875,8551,9936,9754,8388,867,8388,867,6803,2635,7761,3863,3863,9603,7135,2749,9787,9787,5484,5484,5484,2986,2986,2946,9667,754,148,10229,6710,1461,1917,179,10278,9655,2761,4029,10566,10761,6953,3872,10786,961,10649,10346,6953,9855,10905,8358,10892) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC