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,6390,6371,6533,3838,820,2969,8361,8210,7091,8287,7289,7289,8073,8206,8078,7154,8368,8288,8288,323,964,8268,5548,5548,8544,1296,3864,8236,8425,8425,9739,9739,9286,1624,9659,10342,9950,6276,4563,10704,6843,10909,10676,10687,7804,9857,9513,9006,10539,2157,5000,9062,9803,6239,3609,6237,10539,10566,6291,8256,10113,7752,8088,7881,8727,6688,10544,10679,11101,2253,11272,11289,3327,10865,10975,8946,10910,11373,7752,10114,11361,6103,4659,8088,892,10362,10670,6237,10228,5806,2969,3838,11489,7159,11551,9863,8586,10836,8256,9383,10687,11121,11325) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC