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,6376,6517,6989,6743,6750,6746,4614,7610,7103,11085,6768,11082,8582,6199,6198,6200,9632,9631,10445,3898,10981,6201,10948,9150,10947,8346,8345,7311,11429,9794,8228,1704,9076,4804,8771,7697,3515,7694,1666,7608,3442,7696,7646,7150,7868,7696,8432,11052,51,9970,9906,11238,11294,7986,527,3877,6806,8955,9520,11310,4512,11319,11356,11355,11357,6271,10561,3889,10994,7987,6928,7986,8695,3884,6527,8656,9149,8655,11082,10999,979,11391,11085,10433,9144,11011,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,10811,11254,7186,11418,9920,11251,7870,7188,10821,6200,9632,4463,11493,7267,10890,7546,11431,10565,11462,11192,8451,7182,11321,11016,10642,10639,11245,11218,7185,11320,10646,11463,10752,11422,9633,11191,11193,10643,10612,10644,7176,7172,11570,11650,11019,1557,11011,11032,11354,11723,11252,8362,735,6596,8200,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC