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,5719,7304,6140,4769,2474,5718,5718,5718,8353,8353,8725,7903,6183,6183,6183,6183,6183,1988,1988,4920,8527,8527,2342,2342,8970,3598,8613,3823,1988,1988,7861,6103,675,6831,3409,5947,169,6740,7238,8220,8220,7913,7913,8733,1380,8516,8516,9338,9784,7874,9762,9846,9488,8302,9322,435,4784,6174,9951,4788,4788,1207,8885,5251,6752,9049,1425,8171,1198,10235,8171,1533,6691,2467,6691,2447,7396,2294,1253,5817,5545,5817,1347,4258,7883,608,1699,7126,7920,8999,9937,7849,10065,10292,5339,10065,5295,6691,6691,8171,10568,8111,6691,10296,10211,10671,1296,10664,7591,9812,2294,1253,7841,4437,10491,10541,10631,10819,8628,2989,3108,3108,3105,3105,6286,7048,4991,4991,10670,10670,1785,1785,1785,7216,7216,10881,10881,10026,8577,2399,7385,993,6276,1973,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8859,7539,1084,427,1084,427,1084,427,7385,7385,7385,7385,7385,7385,7385,7385,1591,9524,1591,9524,1358,3863,9524,7912,9862,6214,4299,4293,4287,9726,5718,1616,4291,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,6197,10522,10534,10436,10502,9632,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10424,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,6354,3070,3073,3071,6689,6688,9679,8943,7753,7752,8088,9037,8627,8944,9665,10053,10975,10544,8946,8727,10930,10844,7881,8945,10927,10926,10931,11082,11085,7870,8586,10930,10975,10928,9522,9515,9517,9520,9518,10379,9521,10522,11109,2643,10521,10346,10546,10463,10436,10402,10750,10612,10827,10545,11011,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC