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,1268,6691,3941,778,2294,1776,5927,4568,1774,7270,7217,7153,7374,4432,6584,6664,7285,322,7277,3455,5020,7842,1325,3162,7834,7261,7287,7287,7287,7287,7287,7287,7287,7287,8050,6270,6954,2029,1645,8063,6718,7834,698,7836,6349,6365,217,6620,7208,8938,7493,7563,7563,9027,2520,8782,7654,8358,6980,9949,8864,6774,6715,6715,10208,10208,9,9,8299,1571,1953,8830,1624,7837,1571,10891,9866,8047,5066,5056,10717,5064,5053,7391,1461,4061,6631,7493,7437,7389,778,1732,7467,4999,5872,6619,1571,6275,4991,4991,6586,6715,6715,6715,3555,3555,3555,3555,3555,6295,6295,6295,3105,6402,6402,6402,6548,6400,6400,6400,6400,6400,2005,1807,2069,3823,6728,4998,8255,9946,7048,8715,7535,9340,6482,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC