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,7486,7388,7431,7506,8865,8864,8867,8867,8868,6768,2658,7897,947,6658,2005,8866,8866,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,585,7238,182,1145,4947,7124,7083,7122,7666,7115,7268,7115,7100,7094,7152,7246,7119,7072,6432,4399,7493,7476,7476,7535,7977,8514,8514,7247,7241,7241,7069,7467,7467,7506,7506,7437,9019,9019,9019,9024,7501,7457,7457,7457,7457,7457,7457,8861,7491,7389,7574,7084,7093,8580,7297,7486,6482,8460,7268,9264,7674,9264,9022,9022,9022,6367,6367,7083,6691,6691,8,5947,5947,7654,9999,9999,7273,7273,7273,7084,6583,6583,8700,7421,7416,7389,7388,7387,7528,7412,7541,7445) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC