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,8467,10029,7285,10025,8383,9560,9995,9442,9058,7766,9659,9821,9562,8768,9133,9578,9206,8039,10889,10007,7094,10843,10742,7270,10730,8722,7289,8070,7175,9367,6702,10692,10692,9988,220,10480,5770,4574,10038,18,9975,10301,8011,8668,1662,4769,6727,6984,6804,10649,5858,10936,10898,10736,6984,10696,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,10176,2342,10218,10379,6215,10438,9394,6538,6656,1296,9342,6373,10305,6512,10369,10631,10687,8710,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,8292,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10402,10987,10676,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,10840,8191,3890,7987,7808,11209,5297,8682,3896,11215,8255,11307,10646,9129,3358,8244,6688,11322,8897,10520,11049,7176,8874,11013,8618,11015,7632,11432,11414,11463,9865,10932,11204,11147,10326,11205,5635,11418,9524,9863,8963,11489,9951,6822,10966,5435,9418,10892,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10909,10339,11900,11363,11215) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC