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,4146,6103,5742,8005,1242,6132,1044,7974,6103,6687,9118,3395,6367,308,6977,6700,7828,7148,7148,2897,2897,6129,6133,7976,8128,4716,8128,4716,1777,1777,7067,7067,7067,6394,9350,8024,7916,6127,8497,10211,10304,5718,6004,6235,1151,4742,5279,2033,744,2658,3368,5148,7833,5251,2932,5576,4701,9221,5484,10292,4510,4784,10039,9258,8949,7376,9007,7806,4557,7218,10000,10811,9649,1016,9441,7505,6547,10768,9866,11373,11661,10687,11385,3582,9603,10836,10056,11402,10707,8517,6870,10187,10702,1770,2261,9899,7048,8544,7854,7493,6547,9899,10705,10954,10553,10670,11091,10487,6426,11175,1769,11149,11157,10606,1928,11241,11185,11176,11154,10849,10868,10970,11184,8175,9416,10323,7568,9184,10216,8596,1770,10489) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC