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,6794,6189,1738,5877,6971,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,2571,4834,4769,6578,6727,1707,4422,9112,8873,4437,863,9111,8872,9113,4860,8649,8872,9049,4920,1826,650,6565,7147,1085,1086,3850,358,5915,7160,840,7548,6589,6130,4597,2117,2628,975,2555,3525,7869,8223,734,5419,3760,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,6189,3216,435,344,5572,6645,228,1145,5839,6540,6122,6544,6172,6257,1425,1210,5777,3825,501,2594,5459,3302,6350,933,4079,463,5305,7850,3428,6544,6971,501,766,4860,4796,3217,4861,3264,2164,8390,2632,8306,3989,6167,4454,8781,6740,319,5995,7238,6365,6350,6660,4936,7878,6982,7795,7787,1200,7718,5915,2183,6983,3892,7592,7837,7546,6725,7143,1603,947,8095,7992,6589,933,3519,7869,7995,8096,7938,6172,6159,8223,6605,8093,8271,8226,8611,8555,3046,6135,8220,6766,1200,7882,6562,3216,7812,5371,7995,358,2029,8020,2328,6871,8093,6589,5915,6695,8390,8281,6122,6971,6350,6766,7795,7158,7869,5956,2573,6812,7903,8230,8296,6971,8781,8009,9010,8305,1453,3549,8019,9047,9063,8526,7910,4454,6809,9321,7840,6350,6169,7879,7878,8850,6941,1453,9030,9063,4735,8545,9047,6168,6001,1453,9185,9047,9321,8535) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC