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,6743,9088,8984,9176,9089,6377,6367,5269,9087,6386,8857,3926,860,9233,8788,8899,863,8987,7190,7194,9137,9172,8982,6929,7971,7576,8981,6926,6933,6650,8879,6742,7703,6744,6936,8700,7104,7646,397,6144,7150,7297,6743,7099,8980,7122,8982,2856,6749,6349,6751,1730,8983,6750,546,9500,6935,2992,8824,8583,5297,5386,7184,7176,7178,6654,7180,9781,8307) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC