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,8618,9084,8585,7870,7631,8584,8948,7808,10265,1685,5297,5386,6216,6497,8566,10433,8729,381,7024,8729,8584,8788,10056,10522,7721,8728,10520,4390,9909,8922,551,9767,10502,8584,7870,6198,9522,1266,9521,6042,9515,9517,550,10637,10794,10793,10639,10791,10646,10790,10519,10846,9084,10545,8618,3066,11017,9624,3018,11052,8917,9651,6501,7608,10326,10970,10327,7300,10645,10607,10753,10329,10324,10562,11089,11218,7808,9084,10827,7610,10520,10521,10669,11101,11049,6354,10728,10336,9880,10642,10644,10641,7631,11321,9084,10328,6354,10752,11320,11050,11493,10637,11432,10141,10643,8842,5419,10827,7808,4320,6354,9865,11017,8971,9233,9555,8816,9534,10822,3897,368,1770,10239,10821,8232,11255,10443,10612,6270,8878,9483,9143,6749,6197,4297,9155,3881,7632,9217,4296,11320,4464,6742,9156,4301,6745,4293,9154,8983,9231,4298,8980,10957,4292,8879,9151,4300,10646,9147,4305,9144,10640,4294,10645,9633,9146,5635,8729,6743,10639,4289,10752,10753,10642,10641,11427,10644,9792,11081,10643,10647,11080,4304,11321,4390,10545,10828,11076,11077,8982,8981,10637,11432,10520,9149,10827,10646,10752,11320,2605,1266,9137,10637,10647,10639,9949,1765,1770,11321,10645,11432,4390,11017,1685,11466,6484,11218,8585,11723,6103,11385,7610,11052,7311,11365,11251,11421,11130,11419,11422,7892,11013,7697,3997,10981,7696,5635,1927,9555,10906,11187,11463,3997,11116,11269,6653,11063,11376,788,4386,7172,11402,3442,7186,7286,10272,8228,7715,10850,8364,7176,11370,11431,8280,11515,9082,9473,4558,11539,11497,9500,10433,11556,7890,5763,7269,9959,11496,6873,8965,10655,176,2145,10655,176,2145,10655,10805,7178,10480,11365,11795,1016,11780,2791,7179,11150,11768,10526,11746,7374) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC