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,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,261,314,3074,3702,5996,7915,3334,7722,7938,1811,1831,567,8250,7992,1783,8316,3883,8411,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,4234,4234,6584,5956,5956,6771,4566,8031,228,3254,2071,8236,8404,6788,2520,9925,8531,9493,2627,6534,6533,801,9,6506,2783,2782,2778,6443,2780,2781,9950,26,6768,2555,7258,7115,1988,6578,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,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,7304,9030,4302,6742,7473,1988,6242,4317,3074,6174,6814,7964,8686,9351,3337,3823,1462,2417,1250,7473,10932,10916,9601,6953,8780,4923,3327,11216,4769,10874,10731,11379,10579,6715,5647,9685,9693,840,2913,9692,9713,11298,11661,2989,8648,1116,4801,6855,9787,6898,272,8820,6388,7311,7610,6600,6416,7922,8944,7881,9679,10232,6416,9383,10427,9867,6386,10232,10431,8566,6377,545,3887,537,7703,14,6200,7166,9902,8885,8693,726,810,10613,10386,9172,10387,10098,9734,10420,9905,9735,10638,10383,9601,10429,9909,9087,10643,8011,10645,8696,8232,10432,10644,10640,365,1411,4614,10421,10637,10334,2701,6332,10389,10433,9733,10520,10443,6381,6380,10431,7192,7190,10213,10222,10162,10725,9892,6385,7715,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,7048,4178,10818,11028,6367,10649,10892,1777,6793,4362,9386,11253,10212,9320,10505,9865,11219,11195,10248,9871,6240,11169,11217,10687,11379,9420,10831,5269,10002,10893,4716,10282,11349) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC