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,3409,7107,2843,314,3874,314,7078,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5897,5996,5996,2992,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,4801,4801,8820,7160,8223,8526,8547,8815,314,6940,6712,924,4735,6845,3041,7897,6986,8151,6188,2183,6785,3172,4144,1029,1371,8554,7238,6119,6367,6102,5719,1886,3449,2117,374,547,6544,6631,3913,5435,6820,7576,6122,8547,5602,8839,8590,1085,1086,1084,5994,7148,8122,8976,8130,8659,2117,6675,4901,7175,5188,9028) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC