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,4788,10505,11216,11142,1371,6740,1770,10296,10296,10296,582,8388,582,8388,3327,3327,10687,10339,10687,10339,8388,11101,11327,10472,4923,9524,9865,1993,9865,9257,10868,2913,5376,8520,4563,11437,2658,2989,8826,11485,9865,9391,2467,11672,11594,180,8222,11661,11497,11658,9946,5988,10687,10481,10677,11497,10304,6367,10678,906,4401,906,9603,10676,11403,8970,4144,4923,10940,6733,11263,11432,10703,11799,11637,10717,10522,5134,721,10682,6642,11399,11024,9258,9863,11720,7903,11497,9865,8110,11433,11214,10164,10526,11227,5956,10408,11346,11399,9727,10035,1044,8885,2458,7909,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,7368,6367,10707,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,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1973,3863,11366,10731,6548,9863,11373,11601,1807,2627,11497,11739,10687,11739,2872,6102,11497,8302,1811,11346,6718,8686,9547,8434,10169,9865,8922,9972,6717,10707,6978,10290,1983,2137,1811,10874,11292,11215,10372,10687,7708,11444) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC