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,6817,7920,7833,6444,2294,1825,7888,6548,8793,6844,6984,8887,8196,5863,6578,6006,6631,3266,1380,1380,9988,220,10480,5770,4574,10038,18,9975,10301,8011,8668,1662,4769,6727,6984,6804,10649,10936,10984,10898,10736,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,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,10233,10063,6134,9220,10079,6104,10473,10300,10397,10065,9290,10569,10050,10683,587,10472,10646,8517,9752,9984,2555,582,10739,10918,2998) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC