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,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,1586,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,5717,5770,4437,7828,4437,7828,6123,7307,7953,1462,7953,1462,2830,2830,9788,9801,9524,8947,9868,9340,8563,8563,10310,2997,2766,2389,358,6364,1402,217,11658,11774,1250,11650,11660,11659,10454,10321,9537,11662,9543,11657,9679,10228,9889,10860,4701,11770,6102,9274,5269,6259,9959,11831,11905,11829,11829,3850,11266) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC