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,6928,6758,6911,6757,6391,6753,3247,6917,6719,6763,6764,6765,6762,6761,6414,2282,6932,6754,6752,6423,6935,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,6426,2282,6191,6911,6758,6763,6932,6926,2274,6757,6935,2275,6423,2261,6760,6761,6763,6762,1038,6759,858,4395,8596,6545,864) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC