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,5936,1359,3863,1049,6880,7391,7391,1537,7563,7304,7731,344,6645,2032,447,4178,1215,1257,5995,8520,840,585,7238,182,1145,4947,7124,7083,7122,7666,7115,7268,7115,7100,7094,7152,7246,7119,7072,6432,4399,7493,7476,7476,7420,7977,8514,8514,6365,3532,3169,7264,3169,4659,7548,8034,1487,3904,4360,8045,8049,8282,6870,7154,6870,6870,6870,7998,7999,7999,8199,8288,8067,8446,8469,8424,7268,8709,8864,7251,6693,389,6907,5883,6693,386,386,8788,393,8789,1524,9021,9021,8859,8859,372,6768,2658,7897,947,6658,2005,8866,8866,7420,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,6702,8063,7655,8229,8942,8942,6121,1970,8290,2635,2635,9417,9581,8542,9649,9649,9649,9649,9649,9771,8255,9946,7048,8715,9340,4996,6482,11101,7528,10526,9853,10836,9899) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC