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,11101,11216,10953,10960,11117,11117,11101,10687,8139,10670,10296,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,8828,7825,10211,10681,5981) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC