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,6870,7775,8220,6740,9043,9044,9043,9266,9303,9300,10468,10478,7639,3327,5435,10212,10060,6550,7788,10211,10116,5913,1097,7910,5810,7869,10736,1458,8541,10649,4659,10296,1308,8290,2458,5567,5402,7828,2913,7775,916,9934,10986,6700,10758,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,11283,11283,10669,6616,10985,9866,7804,4226,10211,10172,7806,3336,4362,721,576,7219,11121,1993,11701,10211,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7491,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,11215,11380,3105,3108,7383,7409,7408,7406,10687,11739,2872,6102,11497,8302,1811,11346,6718,8686,9547,8434,10169,9865,8922,11400,9972,6717,6978,10290,1983,5484,10292,4510,8303,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,8517,6870,10187,10702) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC