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,3863,5742,3334,1973,5717,2145,5733,6593,6814,3334,3338,7012,7238,3248,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,6484,9866,1807,4996,3823,6728,4998,6631,1624,2005,1624,2005,1462,508,1462,508,1462,508,6391,8665,3336,7505,4769,1624,9547,1609,6623,1609,6623,1609,6623,8881,10098,8881,10098,8881,10098,7592,10056,4639,7304,8747,2998,2998,9879,9879,9879,11025,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,10831) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC