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,6866,6542,2520,5371,2261,6869,1769,6840,6869,6754,857,1516,1245,1616,2696,6804,4426,7020,7092,7082,7095,7121,7097,4490,958,7085,7093,6813,1165,6118,10387,10489,10432,653,10520,10594,6417,10444,6388,10696,6393,7917,10797,10796,10795,10794,10793,10791,3896,3889,7986,10790,11602,11085,11204,11206,11207) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC