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,10133,10144,10081,10204,9318,7884,9559,6795,4906,1497,9336,10355,9031,9649,8489,10380,5810,10145,10672,10667,10658,892,10056,10836,10893,10870,10550,10775,10861,10738,11021,11051,10637,11375,9232,7249,7019,3712,9370,8045,11306,10907,9589,4791,11337,9855,10587,10614,1084,11336,3389,1604,6426,6831,11266,10912,11134) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC